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

This message: [ Message body ]
Next message: support email: "Re: Retrieving result sets from Stored Procedures using ODBC"
Previous message: Terry Banicki: "Re: Database/System Monitoring Software"
In reply to: Darren Ko: "Create, Delete, View users in svrmgr"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message