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_at_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 - 18:44:38 CEST

Original text of this message