Show TOC

Deleting Database UsersLocate this document in the navigation structure

Prerequisites

  • The database is in the ONLINE operational state.

  • You are logged on to the database as database system administrator or as a database user of the DBA user class and are the owner of the database user you want to delete.

Context

When you delete a database user, all schemas, synonyms, and tables of that user are also deleted, along with all related indexes, privileges, view tables, and so on.

Note though that deleting a user of the DBA user class does not affect any database users created by this user. The database system administrator becomes the new owner of these database users.

Procedure

  1. Select the database in the explorer tree.
  2. In the context menu of the users, select the user.
  3. Choose Delete.

Next Steps

Managing Users: Overview

Database Administration, Database Users