Enables you to drop
authorization identifiers.
DROP { AUTHID | AUTHORIZATION [IDENTIFIER] } "ID" [TRANSFER TO
name] [CASCADE|RESTRICT] [FORCE]
“ID”
Specifies the authorization
identity to drop. The ID must be in quotation marks.
This is the user ID
or the group ID that you can find by using the AUTHORIZATION_IDENTIFIERS
information view.
name
Specifies the authorization
identity that will receive object ownership from the dropped identity.
This user name is created using the Authentication Server.
| FORCE |
Specifies the optional FORCE keyword that will
suppress error messages when the user does not exist
|
| 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 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.
|
drop authid "5E563F78B0D70854086FB3D8441EF9AA" transfer to user2
drop authid "F135005B80DED494E996F70DCC53790D" cascade
drop authid "B8A105927F25B1A47AE8198D1E3C4B86" transfer to user2 force