ASA Database Administration Guide
Managing User IDs and Permissions
Managing groups
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)
Open the Users & Groups folder.
Right-click the desired group and choose Delete from the popup menu.
To delete a group from the database (SQL)
Connect to a database.
Execute a REVOKE CONNECT FROM statement.
Remove the group personnel from the database.
REVOKE CONNECT FROM personnel
See also