DROP USERGROUP statement (SAP Library - Reference Manual 7.2 (BC))

DROP USERGROUP statement

The DROP USERGROUP statement drops a usergroup definition. The metadata of the usergroup to be dropped is dropped from the catalog.

Syntax

<drop usergroup statement> ::= DROP USERGROUP <usergroup name> [<cascade option>]

Explanation

The current user must have owner authorization over the usergroup to be dropped.

The users in this usergroup must not be logged onto the database system when the DROP USERGROUP statement is executed.

If the usergroup to be dropped does not belong to a usergroup and 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 is specified, all the synonyms and tables of the usergroup to be dropped, as well as all indexes, privileges, view tables, etc. based on these objects, are dropped.