Re: Create, Delete, View users in svrmgr

From: support email <msftmail_at_us.oracle.com>
Date: Mon, 24 May 1999 16:44:38 GMT
Message-ID: <374c8114.8661104@newshost.us.oracle.com>

DBA_USERS contains most of the information you will want:

SQL> describe DBA_USERS
 Name

---

 USERNAME
 USER_ID
 PASSWORD
 ACCOUNT_STATUS
 LOCK_DATE
 EXPIRY_DATE
 DEFAULT_TABLESPACE
 TEMPORARY_TABLESPACE

 CREATED                                   
 PROFILE                                      
 INITIAL_RSRC_CONSUMER_GROUP                                   
 EXTERNAL_NAME                                                 

SQL>  Removing a user can be as simple as:
DROP USER SCOTT CASCADE; Forcing all of the objects owned by SCOTT to be removed as well. Received on Mon May 24 1999 - 11:44:38 CDT