Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle create duplicate user account

Re: Oracle create duplicate user account

From: rcyoung <rcyoung_at_aliconsultants.com>
Date: 14 Mar 2007 06:48:09 -0700
Message-ID: <1173880089.632112.139110@p15g2000hsd.googlegroups.com>


On Mar 9, 12:37 pm, trp..._at_gmail.com wrote:
> I am looking for the SQL syntax to create an additional database user
> that is a copy of an existing user. So my new user will have a
> different username and password, but same permissions and access as
> another existing user. I am looking for the SQL syntax, not how to do
> it through a GUI tool.
>
> Thanks!

You might try something like this

  1. export with no data
  2. import with the list option so that you put a copy of ALL the SQL into a text file, but it is not actually executed
  3. Edit the text file to extract and change the specifics features you need for a new user, making it identical to the existing user
  4. Run the script you just created

This way you "know" you have all privs,roles,etc taken care of. Received on Wed Mar 14 2007 - 08:48:09 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US