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
lokhande.dinesh29
Messages: 36
Registered: May 2007
Member
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.
or
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.

Regards,
Dinesh
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: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No, you can only grant SELECT on existing objects and object by object.

Regards
Michel
Previous Topic: whats the difference b/w procedure and transaction in oracle?
Next Topic: Null comparison
Goto Forum:
  


Current Time: Sat Dec 10 04:45:50 CST 2016

Total time taken to generate the page: 0.08966 seconds