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.
Open the Users & Groups folder.
Select the desired user and then choose File > Delete.
Execute a REVOKE CONNECT FROM statement.
Remove the user M_Haneef from the database.
REVOKE CONNECT FROM M_Haneef;