Home » SQL & PL/SQL » SQL & PL/SQL » Regarding Object level privileges........
Regarding Object level privileges........ [message #246592] Thu, 21 June 2007 07:23 Go to next message
Messages: 36
Registered: May 2007
Hi All,

Is it possible to assign SELECT privilege on all the objects in a schema & according to my situation: at present i don't have any object in that schema.
in other words: i just created one schema(it contains no object) & for future reference, can i assign select privilege to other user on all the objects.

Re: Regarding Object level privileges........ [message #246595 is a reply to message #246592] Thu, 21 June 2007 07:32 Go to previous message
Michel Cadot
Messages: 65143
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No, you can only grant SELECT on existing objects and object by object.

Previous Topic: Null comparison
Next Topic: Reg : Comment (Drop)
Goto Forum:

Current Time: Sat Aug 19 06:26:29 CDT 2017

Total time taken to generate the page: 0.12274 seconds