The Firebird 5.0 Language Reference | CREATE OR ALTER MAPPING

Creating or altering a mapping

CREATE OR ALTER MAPPING FROM_RT
  USING PLUGIN SRP IN "rt"
  FROM USER U1 TO USER U4;

`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

Alter mapping

DROP MAPPING FROM_RT;