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: 63923
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: whats the difference b/w procedure and transaction in oracle?
Next Topic: Null comparison
Goto Forum:

Current Time: Tue Oct 25 23:44:54 CDT 2016

Total time taken to generate the page: 0.17048 seconds