DROP AUTHID Statement

Enables you to drop authorization identifiers.

DROP { AUTHID | AUTHORIZATION [IDENTIFIER] } "ID" [TRANSFER TO
name] [CASCADE|RESTRICT] [FORCE]

AUTHORIZATION IDENTIFIER “ID”

Specifies the authorization identity to drop. The ID must be surrounded in double quotation marks. This is the user ID or the group ID that are found by using the AUTHORIZATION_IDENTIFIERS information view.

TRANSFER TO name

Specifies the authorization identity that will receive object ownership from the dropped identity. This user name is created using the Authentication Server.

Drop disposition

Used to specify additional options.

CASCADE

Specifies the entities are dropped unconditionally. All records that reference the entity are removed. This option is invalid if the TRANSFER TO option is specified.

RESTRICT

Specifies that the drop fails if the entity is the grantor of any privilege. The drop also fails if the entity is the owner of a DSN or schema. This option is ignored if the TRANSFER TO option is specified.

FORCE

Specifies the optional FORCE keyword that will suppress error messages when the user does not exist.

Examples:

drop authid "5E563F78B0D70854086FB3D8441EF9AA" transfer to user2

drop authid "F135005B80DED494E996F70DCC53790D"  cascade

drop authid "B8A105927F25B1A47AE8198D1E3C4B86" transfer to user2 force