Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
SQL Anywhere 10.0.1 » SQL Anywhere Server - Database Administration » Managing User IDs and Permissions » Managing individual user IDs and permissions

Revoking user permissions Next Page

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

To delete a user from the database (Sybase Central)

  1. Open the Users & Groups folder.

  2. Select the desired user and then choose File > Delete.

    3. To delete a user from the database (SQL)
Example

Remove the user M_Haneef from the database.

REVOKE CONNECT FROM M_Haneef;
See also