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, as well as any external logins for the user.

Only a user with DBA authority can delete a user.

 To delete a user from the database (Sybase Central)
  1. Use the SQL Anywhere 12 plug-in to 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
 See also