OraFAQ Forum: Security » Copy *all* object privileges to new schema user

Home » RDBMS Server » Security » Copy *all* object privileges to new schema user

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

Copy *all* object privileges to new schema user [message #357296]

Tue, 04 November 2008 14:13

bogey
Messages: 53
Registered: February 2006

Member

I'm a little stumped on this one. We are in the process of updating our applications and we are creating new schema users for security reasons. We'll want to keep the existing schemas but would like to assign privs to the new users. If I want to grant select on all tables, views do I need to loop through and do this one by one ??

Report message to a moderator

Re: Copy *all* object privileges to new schema user [message #357299 is a reply to message #357296]

Tue, 04 November 2008 14:25

Michel Cadot
Messages: 68774
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Yes but it is easy to generate a script for this and you will find many here.

Regards
Michel

Report message to a moderator

Re: Copy *all* object privileges to new schema user [message #357302 is a reply to message #357299]

Tue, 04 November 2008 14:51

bogey
Messages: 53
Registered: February 2006

Member

I've been looking.

I need tables, procedures, sequences, functions, views ... Is there no easier way to do this ?

I can query the sys views for the ALL_[OBJECTS] and run this but I'm not able to find the functions.

Report message to a moderator

Re: Copy *all* object privileges to new schema user [message #357324 is a reply to message #357302]

Tue, 04 November 2008 22:44

Michel Cadot
Messages: 68774
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

I can query the sys views for the ALL_[OBJECTS] and run this but I'm not able to find the functions.

You missed something.

Regards
Michel

Report message to a moderator

Previous Topic:	User SYS logged without password locally
Next Topic:	OID - Importance of Wallet in OID without SSL and Other problems

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 24 13:03:42 CST 2026