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

To delete a group from the database (Sybase Central)

Connect to the database as a user with DBA authority.
Click Users & Groups.
Right-click the group and then choose Delete.
Click Yes.

To delete a group from the database (SQL)

Connect to the database as a user with DBA authority.
Execute a REVOKE CONNECT FROM statement.

Example

Remove the group personnel from the database.

REVOKE CONNECT FROM personnel;

Deleting groups from the database

Example

See also