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

To delete a user from the database (Sybase Central)

Connect to the database as a user with DBA authority.
Click Users & Groups.
Right-click a user and then choose Delete.
Click Yes.

To delete a user from the database (SQL)

Connect to the database as a user with DBA authority.
Execute a DROP USER statement.

Example

Remove the user M_Haneef from the database.

DROP USER M_Haneef;

Deleting users from the database

Example

See also