Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Create user as other user

David Luis Moya GarridoMay 27 2015 — edited Jan 11 2016

I remember that in Oracle Enterprise Manager 8i,9i ( and 10g java console) you could create user as other user, but

i think that you can´t do it in sql.

(https://docs.oracle.com/database/121/SQLRF/statements_8003.htm#SQLRF01503)

the idea is something like this:

Create user mike like scott identified by p4ssw0rd;

"Like scott" involves:

    grant to mike the same system privileges that scott has.

  

    grant to mike the same roles that scott has.

  

    grant to mike the sames tablespace quotas that scott has.

  

    set the same default/temporary tablespace  as scott.

  

    set the same profile to mike like scott has.

  

   

I don´t like to grant the same object privileges...but this is an personal opinion.  

today you can do something similiar using dbms_metadata...but this new feature would be more easy to use.

Comments
Post Details
Added on May 27 2015
9 comments
9,371 views