F.2. SEC$GLOBAL_AUTH_MAPPING

Lists users and roles granted the CREATE DATABASE privilege.

Column NameData TypeDescription

SEC$MAP_NAME

CHAR(31)

Name of the mapping

SEC$MAP_USING

CHAR(1)

Using definition:

P - plugin (specific or any) S - any plugin serverwide M - mapping * - any method

SEC$MAP_PLUGIN

CHAR(31)

Mapping applies for authentication information from this specific plugin

SEC$MAP_DB

CHAR(31)

Mapping applies for authentication information from this specific database

SEC$MAP_FROM_TYPE

CHAR(31)

The type of authentication object (defined by plugin) to map from, or * for any type

SEC$MAP_FROM

CHAR(255)

The name of the authentication object to map from

SEC$MAP_TO_TYPE

SMALLINT Nullable

The type to map to

0 - USER 1 - ROLE

SEC$MAP_TO

CHAR(31)

The name to map to