Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.1 » SQL Anywhere Server - Database Administration » Database configuration » User IDs, authorities, and permissions » Groups

 

Deleting a group from the database

 Delete a group from the database (Sybase Central)

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 a user with DBA authority can delete a group.

  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 the group and then click Delete.

  4. Click Yes.

 Delete a group from the database (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 a user with DBA authority can delete a group.

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

  2. Execute a REVOKE CONNECT FROM statement.

 See also
 Example