Home » RDBMS Server » Security » grant schema level privilege to other user
grant schema level privilege to other user [message #56314] Tue, 18 March 2003 14:59 Go to next message
jie gao
Messages: 6
Registered: March 2002
Junior Member
Hi,
I need to assign a user with all the objects (table, view, stored procedure etc.) privileges owned by another user. I am wondering if there is a better way without granting them object by object.

Thanks in advance.

Jie Gao
Re: grant schema level privilege to other user [message #56317 is a reply to message #56314] Wed, 19 March 2003 04:59 Go to previous messageGo to next message
Ritesh Kumar
Messages: 18
Registered: February 2003
Junior Member
1. You could create a role that has privilege on the user objects and grant that role to other users.
2. You could create a pl/sql program that would in a loop, read all the objects owned by a user and grant permissions on it to other user(s).
Re: grant schema level privilege to other user [message #56319 is a reply to message #56314] Wed, 19 March 2003 06:00 Go to previous message
Mahesh Rajendran
Messages: 10697
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Please follow up with our [url=http://www.orafaq.net/msgboard/server/messages/18683.htm] other posting [/url].
It is discussion about how to create a user "LIKE" an existing user. There is also a script given.
Just alter the script as your need ( You may not be in need to create a new user)

Previous Topic: DEFAULT PASSWORDS TO CONNECT TO A NEW INSTANCE
Next Topic: Creating a Secure Application Role
Goto Forum:
  


Current Time: Mon May 16 19:28:22 CDT 2022