Procedure documentationDeleting Database Users Locate this document in the navigation structure


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.


  • 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.


This function has not been implemented in Database Studio yet. Use the corresponding SQL statement instead.

More information:

More Information

Database Administration, Database Users