Grant Read

[Arijit Chatterjee]

Hi,
I have created a DB in Administrator login.And also added many tables
with that login.Now when I writing

Grant Read ON <Table Name> TO Users
Getting the prompt
"Invalid SQL statement;expec ted
'DELETE','INSER T','PROCEDURE', 'SELECT',or
'UPDATE'.

Please help me out.
Thanks in advance.
Regards
Arijit Chatterjee

[MGFoster]

Re: Grant Read

Arijit Chatterjee wrote:[color=blue]
> Hi,
> I have created a DB in Administrator login.And also added many tables
> with that login.Now when I writing
>
> Grant Read ON <Table Name> TO Users
> Getting the prompt
> "Invalid SQL statement;expec ted
> 'DELETE','INSER T','PROCEDURE', 'SELECT',or
> 'UPDATE'.[/color]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

If you are using a JET db (common Access db engine used in .mdb files),
it doesn't have any of the permission commands. You have to set object
permissions thru the Access user security options. Look, on the main
menu bar, at Tools > Security > User-level security wizard. Also, read
the security FAQ available at this site:

http://support.microsoft.com/default.aspx?scid=kb;en-us;207793

--
MGFoster:::mgf0 0 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQjHffIechKq OuFEgEQLsagCg7j B/9FYun7sLWuUKk8s uakmPh3YAn19o
6bdLrst6F0fPNfo YWBc0c5qW
=EjDq
-----END PGP SIGNATURE-----