sp_DropGroup

Advantage SQL Engine

Delete a user group object from the database.

Syntax

sp_DropGroup( GroupName,CHARACTER,100 )

Parameters

GroupName (I)

Name of the user group object to delete.

Special Return Codes

AE_INVALID_OBJECT_NAME

Possible cause for the error is that the GroupName is not a valid user group name in the database.

Remarks

sp_DropGroup removes an existing user group from the database. All references to the user group by the database users are removed from the data dictionary.

Example

After making a connection to the database, delete the user group named "Managers" from the database.

EXECUTE PROCEDURE sp_DropGroup( ‘Managers’ );

See Also

sp_CreateGroup

sp_ModifyGroupProperty

sp_CreateUser

sp_DropUser

sp_AddUserToGroup

sp_RemoveUserFromGroup