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 groups

Special groups Next Page

Deleting groups from the database

You can delete a group from the database using both Sybase Central and Interactive SQL.

Deleting users or groups from the database is different from removing them from other groups. Deleting a group from the database does not delete its members from the database, although they lose membership in the deleted group.

Only the DBA can delete a group.

To delete a group from the database (Sybase Central)
  1. Open the Users & Groups folder.

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

  3. To delete a group from the database (SQL)
    1. Connect to a database.

    2. Execute a REVOKE CONNECT FROM statement.

    3. Example

      Remove the group personnel from the database.

      REVOKE CONNECT FROM personnel;
      See also