Home » RDBMS Server » Security » Creating User With same Privilages as Existing User (10g,Sun OS)
Creating User With same Privilages as Existing User [message #421061] Fri, 04 September 2009 00:46 Go to next message
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.
Re: Creating User With same Privilages as Existing User [message #421065 is a reply to message #421061] Fri, 04 September 2009 00:56 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Query dba_role_privs, dba_sys_privs, dba_tab_privs, dba_col_privs, for instance.

Regards
Michel
Re: Creating User With same Privilages as Existing User [message #421177 is a reply to message #421061] Fri, 04 September 2009 21:32 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
You could also utilize OEM and use the "Create Like" functionality.
Re: Creating User With same Privilages as Existing User [message #422998 is a reply to message #421061] Mon, 21 September 2009 12:24 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://www.orafaq.com/forum/t/46236/0/
icon7.gif  Re: Creating User With same Privilages as Existing User [message #430259 is a reply to message #422998] Mon, 09 November 2009 16:19 Go to previous message
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
Previous Topic: session details in v$session
Next Topic: Privileges granted to role
Goto Forum:
  


Current Time: Thu Mar 28 14:40:37 CDT 2024