Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle create duplicate user account
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
This way you "know" you have all privs,roles,etc taken care of. Received on Wed Mar 14 2007 - 08:48:09 CDT
![]() |
![]() |