OraFAQ Forum: Security » Creating User With same Privilages as Existing User

Home » RDBMS Server » Security » Creating User With same Privilages as Existing User (10g,Sun OS)

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

Creating User With same Privilages as Existing User [message #421061]

Fri, 04 September 2009 00:46

madhavamanohar
Messages: 58
Registered: February 2009

Member

Hi Experts,

Please tell me the process how to find out all privileges for an existing user and I want to crate a new user with the same privileges as existing user.

Thanks In Advance.

Report message to a moderator

Re: Creating User With same Privilages as Existing User [message #421065 is a reply to message #421061]

Fri, 04 September 2009 00:56

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

Senior Member
Account Moderator

Query dba_role_privs, dba_sys_privs, dba_tab_privs, dba_col_privs, for instance.

Regards
Michel

Report message to a moderator

Re: Creating User With same Privilages as Existing User [message #421177 is a reply to message #421061]

Fri, 04 September 2009 21:32

ebrian
Messages: 2794
Registered: April 2006

Senior Member

You could also utilize OEM and use the "Create Like" functionality.

Report message to a moderator

Re: Creating User With same Privilages as Existing User [message #422998 is a reply to message #421061]

Mon, 21 September 2009 12:24

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

http://www.orafaq.com/forum/t/46236/0/

Report message to a moderator

Re: Creating User With same Privilages as Existing User [message #430259 is a reply to message #422998]

Mon, 09 November 2009 16:19

konark
Messages: 24
Registered: February 2008
Location: Takhsila

Junior Member

If you are using Toad /PLSQL developer,

go to the users page .Click on its scripts Tab.
you will find all the privs given to that user.
Copy and paste in another sql window.
Replace the username and password and you are done.

Wasnt it simple Smile

Report message to a moderator

Previous Topic:	session details in v$session
Next Topic:	Privileges granted to role

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Aug 18 05:44:08 CDT 2025