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: Michel Cadot <micadot{at}altern{dot}org>
Date: Fri, 9 Mar 2007 17:45:35 +0100
Message-ID: <45f18f2e$0$3201$426a74cc@news.free.fr>

<trpost_at_gmail.com> a écrit dans le message de news: 1173458266.313271.77960_at_8g2000cwh.googlegroups.com...
|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!
|

There is no SQL statement for that.
Have a look at:

http://www.dba-village.com/dba/village/dvp_tips.TipDetails?TipIdA=1877

Regards
Michel Cadot Received on Fri Mar 09 2007 - 10:45:35 CST

Original text of this message

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