Contents Index Special groups Database object names and prefixes

ASA Database Administration Guide
  Managing User IDs and Permissions
    Managing groups

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. Right-click the desired group and choose Delete from the popup menu.

To delete a group from the database (SQL)

  1. Connect to a database.

  2. Execute a REVOKE CONNECT FROM statement.

Example 

Remove the group personnel from the database.

REVOKE CONNECT FROM personnel

See also


Contents Index Special groups Database object names and prefixes