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)
  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