DROP MAPPING

`DROP MAPPING`

Drops a mapping of a security object

Available in

DSQL

Syntax

DROP [GLOBAL] MAPPING name

Table 1. `DROP MAPPING` Statement Parameter
Parameter	Description
name	Mapping name

The DROP MAPPING statement removes an existing mapping.If GLOBAL is specified, then a global mapping will be removed.

Important

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

The DROP 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