ASA Database Administration Guide
Managing User IDs and Permissions
Managing individual user IDs and permissions
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)
Open the Users & Groups folder.
Right-click the desired user and choose Delete from the popup menu.
TipsYou cannot delete users when you select them within a group container. |
To delete a user from the database (SQL)
Connect to a database.
Execute a REVOKE CONNECT FROM statement.
Remove the user M_Haneef from the database.
REVOKE CONNECT FROM M_Haneef
See also