Drop a user

You can drop a user by using the DROP USER statement.

Prerequisites

You must have the DROP USER system privilege to execute the DROP USER statement. For information about how to view your privileges, see View user privileges. If you do not have the DROP USER privilege, contact the administrator to obtain the privilege. For more information about how to grant privileges to a user, see Grant direct privileges.

Considerations

Procedure

1. Log on to an Oracle tenant of the cluster.

2. Drop a user.

   The SQL syntax is as follows:

   DROP USER username CASCADE;
   

   where:

   • CASCADE specifies that the system will drop all objects owned by the user, such as privileges, databases, and tables, before it drops the user.

   • username specifies the user to be dropped. Only a single user can be dropped at a time.

   For example, the following statement drops the sqluser user:

   obclient> DROP USER sqluser CASCADE;
   Query OK, 0 rows affected
   

References

For more information about the DROP USER statement, see DROP USER.