A question from a newbie

From: vvenk (vvenk_at_discussions.microsoft.com)
Date: 10/27/04 

Date: Wed, 27 Oct 2004 11:43:01 -0700

Can somebody tell me the correct syntax if I want to grant SELECT privileges
on all tables in a db?

I tried:

GRANT SELECT TO public;

Thanks.

Venkat

Relevant Pages

  • Re: question about user access to tables
    ... They see only some of the tables in the database that the ... they do see are also owned by the ABCADM account. ... and the system privileges assigned to a user. ... user could grant access to the other use; ...
    (comp.databases.oracle.misc)
  • Re: Question about revoking select from PUBLIC
    ... You'll have to revoke SELECT access from PUBLIC and then grant SELECT ... > If I drop the PUBLIC synonyms, nobody except the owner ... cannot REVOKE privileges you did not ...
    (comp.databases.oracle.misc)
  • Re: Question about revoking select from PUBLIC
    ... You'll have to revoke SELECT access from PUBLIC and then grant SELECT ... > If I drop the PUBLIC synonyms, nobody except the owner ... cannot REVOKE privileges you did not ...
    (comp.databases.oracle.misc)
  • Re: WinNT/2000 screen saver with password and Logoff?
    ... > administrators. ... and use the station" privileges. ... This would not grant user B any ... to break a lock is to ensure that nobody can take the lock to begin ...
    (microsoft.public.win2000.security)
  • Re: WinNT/2000 screen saver with password and Logoff?
    ... > administrators. ... and use the station" privileges. ... This would not grant user B any ... to break a lock is to ensure that nobody can take the lock to begin ...
    (comp.os.ms-windows.nt.admin.security)