Home » SQL & PL/SQL » SQL & PL/SQL » schema level
schema level [message #329484] Wed, 25 June 2008 09:54 Go to next message
shoaib123
Messages: 118
Registered: December 2007
Location: Chicago
Senior Member

I need to grant select insert and update of all object exists in my schema to other user.

grant select, update, insert on <object_name>
to <user>


is there any grant option to use to grant all objects to other user by issuing one grant command.
Re: schema level [message #329487 is a reply to message #329484] Wed, 25 June 2008 10:00 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
>is there any grant option to use to grant all objects to other user by issuing one grant command.
not directly but you could write a single SQL statement to generate all the desired GRANT statements.
Re: schema level [message #329490 is a reply to message #329487] Wed, 25 June 2008 10:10 Go to previous message
shoaib123
Messages: 118
Registered: December 2007
Location: Chicago
Senior Member

ok thanks for your generous help
Previous Topic: Query Problem
Next Topic: avoid duplicate runs on dbms jobs
Goto Forum:
  


Current Time: Sun Dec 04 20:28:19 CST 2016

Total time taken to generate the page: 0.10120 seconds