OraFAQ Forum: Security » grant schema level privilege to other user

Home » RDBMS Server » Security » grant schema level privilege to other user

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

grant schema level privilege to other user [message #56314]

Tue, 18 March 2003 14:59

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

Report message to a moderator

Re: grant schema level privilege to other user [message #56317 is a reply to message #56314]

Wed, 19 March 2003 04:59

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).

Report message to a moderator

Re: grant schema level privilege to other user [message #56319 is a reply to message #56314]

Wed, 19 March 2003 06:00

Mahesh Rajendran
Messages: 10708
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)

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 23 16:24:29 CST 2025