The DROP USERGROUP statement (drop_usergroup_statement) deletes the definition of a user group. The metadata of the user group to be dropped is dropped from the database catalog.
Syntax
<drop_usergroup_statement> ::= DROP USERGGROUP <usergroup_name> [<cascade_option>]
The current database user must have owner authorization over the user group to be dropped.
The database users in this user group must not be logged on to the database system when the DROP USERGROUP statement is executed.
If the usergroup to be dropped is the owner of synonyms or tables and if the CASCADE option RESTRICT was specified, the DROP USERGROUP statement fails.
If no CASCADE option or the CASCADE option CASCADE was specified, all the synonyms and tables of the user group to be dropped, as well as all indexes, privileges, view tables, and so on based on these objects, are dropped together with the user group.