- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 62 Insurance
- 536K On-Premises Infrastructure
- 138.2K Analytics Software
- 38.6K Application Development Software
- 5.7K Cloud Platform
- 109.4K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.2K Integration
- 41.5K Security Software
Create user as other user
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.
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.