Re: Oracle create duplicate user account

From: Jaap W. van Dijk <j.w.vandijk.removethis_at_hetnet.nl>
Date: Sat, 10 Mar 2007 11:21:45 GMT
Message-ID: <45f29490.10377671@news.hetnet.nl>

On 9 Mar 2007 08:37:46 -0800, trpost_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!
>

The Enterprise Manager has the Create like ... function (reached by right-clicking on a User)

Jaap. Received on Sat Mar 10 2007 - 05:21:45 CST