9.3 About Delete User

Use this option to delete users.

In the Database Users page, select Delete from the user's context menu to delete a user.


The number of user's active sessions is displayed in the Delete User dialog window.
  • Cascade: If this option is selected, all dependent objects are also deleted.

  • Drop REST Services: If this option is selected, all user REST data is removed from ORDS.


    If you do not select this option when deleting a user, the next time you create a user with the same user name, it will still retain the REST-enabled property.

Click Delete User and a confirmation notification is displayed.


An error notification is displayed, if the user has active sessions. In such cases, you must close the active sessions before you can delete the user.