OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » schema level

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

schema level [message #329484]

Wed, 25 June 2008 09:54

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.

Report message to a moderator

Re: schema level [message #329487 is a reply to message #329484]

Wed, 25 June 2008 10:00

BlackSwan
Messages: 26766
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.

Report message to a moderator

Re: schema level [message #329490 is a reply to message #329487]

Wed, 25 June 2008 10:10

shoaib123
Messages: 118
Registered: December 2007
Location: Chicago

Senior Member

ok thanks for your generous help

Report message to a moderator

Previous Topic:	Query Problem
Next Topic:	avoid duplicate runs on dbms jobs

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 03 05:04:16 CST 2024