ALTER MAPPING

Statements for Revoking PrivilegesDatabase Encryption

`ALTER MAPPING`

Alters a mapping of a security object

Available in

DSQL

Syntax

ALTER [GLOBAL] MAPPING name
  USING
    { PLUGIN plugin_name [IN database]
    | ANY PLUGIN [IN database | SERVERWIDE]
    | MAPPING [IN database] | '*' [IN database] }
  FROM {ANY type | type from_name}
  TO {USER | ROLE} [to_name]

For details on the options, see [fblangref50-security-mapping-create].

The ALTER MAPPING statement allows you to modify any of the existing mapping options, but a local mapping cannot be changed to GLOBAL or vice versa.

Important

Global and local mappings of the same name are different objects.

Who Can Alter a Mapping

The ALTER MAPPING statement can be executed by:

Administrators
The database owner — if the mapping is local
Users with the CHANGE_MAPPING_RULES system privilege — if the mapping is local