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

Home -> Community -> Mailing Lists -> Oracle-L -> user creation with similar profile

user creation with similar profile

From: nilesh kumar <nileshkum_at_gmail.com>
Date: Tue, 26 Jun 2007 22:35:07 -0700
Message-ID: <7877ab4b0706262235m29e939e4v534235c84ac44e6c@mail.gmail.com>


Can any one help to write a sql statement in which , i want to create a new user with a similar profile of different user.Say for example there is a user "A" who has so n so privilege and so n so table space assigned to him etc..., i want to create a user "B" who has the same privilege as A and same tablespace assigned to A etc...

Thanks

Nilesh Soni.

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jun 27 2007 - 00:35:07 CDT

Original text of this message

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