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 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 ...
    (comp.os.ms-windows.nt.admin.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 ...
    (microsoft.public.win2000.security)
  • Re: getting error on UTL_FILE.FOPEN
    ... When you create a directory, you are automatically granted the READ and WRITE object privileges on the directory, and you can grant these privileges to other users and roles. ... CREATE DIRECTORY is only granted by default to SYS and the DBA role. ... it as a schema owner other than SYS or SYSTEM it will not work. ...
    (comp.databases.oracle.misc)