Deleting a user from the database

 Delete a user from the database (Sybase Central)

Deleting a user also deletes all database objects (such as tables) that they own, as well as any external logins for the user.

The user being removed cannot be connected to the database during this procedure.

  1. Use the SQL Anywhere 12 plug-in to connect to the database as a user with DBA authority.

    Only a user with DBA authority can delete a user.

  2. Click Users & Groups.

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

  4. Click Yes.

 Delete a user from the database (SQL)

Deleting a user also deletes all database objects (such as tables) that they own, as well as any external logins for the user.

The user being removed cannot be connected to the database during this procedure.

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

  2. Execute a DROP USER statement.

 See also
 Example