Home » RDBMS Server » Security » Copy *all* object privileges to new schema user
Copy *all* object privileges to new schema user [message #357296] Tue, 04 November 2008 14:13 Go to next message
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 ??
Re: Copy *all* object privileges to new schema user [message #357299 is a reply to message #357296] Tue, 04 November 2008 14:25 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes but it is easy to generate a script for this and you will find many here.

Regards
Michel
Re: Copy *all* object privileges to new schema user [message #357302 is a reply to message #357299] Tue, 04 November 2008 14:51 Go to previous messageGo to next message
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.
Re: Copy *all* object privileges to new schema user [message #357324 is a reply to message #357302] Tue, 04 November 2008 22:44 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: User SYS logged without password locally
Next Topic: OID - Importance of Wallet in OID without SSL and Other problems
Goto Forum:
  


Current Time: Thu Mar 28 05:54:08 CDT 2024