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