Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle create duplicate user account
<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