Members   Search   Help    Register    Login   Home
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: 29
Registered: February 2009
Junior 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 Go to previous messageGo to next message
Michel Cadot
Messages: 29436
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
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 Go to previous messageGo to next message
ebrian
Messages: 2714
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 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 9793
Registered: March 2002
Location: oracleDocoVille
Senior Member
http://www.orafaq.com/forum/t/46236/0/
Report message to a moderator
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
Report message to a moderator
Previous Topic:session details in v$session
Next Topic:Privileges granted to role
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Dec 1 17:32:37 CST 2009

Total time taken to generate the page: 0.14689 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.