Contents Index Revoking user permissions Managing connected users

ASA Database Administration Guide
  Managing User IDs and Permissions
    Managing individual user IDs and permissions

Deleting users from the database


You can delete a user from the database using both Sybase Central and Interactive SQL. The user being removed cannot be connected to the database during this procedure.

Deleting a user also deletes all database objects (such as tables) that they own.

Only the DBA can delete a user.

To delete a user from the database (Sybase Central)

  1. Open the Users & Groups folder.

  2. Right-click the desired user and choose Delete from the popup menu.

Tips 
You cannot delete users when you select them within a group container.

To delete a user from the database (SQL)

  1. Connect to a database.

  2. Execute a REVOKE CONNECT FROM statement.

Example 

Remove the user M_Haneef from the database.

REVOKE CONNECT FROM M_Haneef

See also


Contents Index Revoking user permissions Managing connected users