| User Creation script for Navneet [message #59183] |
Mon, 03 November 2003 05:10 |
Daljit Singh
Messages: 290
Registered: October 2003
Location: Texas
|
Senior Member |
|
|
Hi Navneet,
I found how to extract the user creation script from an existing database. Additionaly u can assign quota on each tablespace to different users in the script. Here it is :
select 'create user ' || dba_users.USERNAME ||
' identified by password default tablespace ' || dba_users.DEFAULT_TABLESPACE ||
' temporary tablespace ' || dba_users.TEMPORARY_TABLESPACE || ' profile ' ||
dba_users.PROFILE || ' password expire'
from dba_users
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
