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 a user with DBA authority can delete a user.

To delete a user from the database (Sybase Central)

1. Connect to the database as a user with DBA authority.

2. Click Users & Groups.

3. Right-click a user and then choose Delete.

4. Click Yes.

To delete a user from the database (SQL)

1. Connect to the database as a user with DBA authority.

2. Execute a DROP USER statement.

Example

Remove the user M_Haneef from the database.

DROP USER M_Haneef;

See also

• DROP USER statement
• REVOKE statement
• Revoking user permissions and authorities
• Deleting groups from the database