GRANT MAP Statement | SQL Data Control Language | Teradata Vantage - 17.05 - GRANT MAP - Teradata Database

Teradata Vantageā„¢ - SQL Data Control Language

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
17.05
created_date
June 2020
category
Programming Reference
featnum
B035-1149-170K

Grant existing contiguous or sparse maps to users and roles.

Users or roles who have been granted a map can specify the map in the MAP, DEFAULT MAP, and EXECUTE MAP options of SQL statements.

Required Privileges

You must have the GRANT MAP WITH GRANT OPTION privilege for the specified map to grant a map privilege.

Syntax

GRANT MAP map_name [,...] TO {
  { user_name | role_name } [,...] |
  PUBLIC |
  user_name [,...] WITH GRANT OPTION
} [;]

Syntax Elements

map_name
Name of existing contiguous or sparse map.
You cannot specify TD_DataDictonaryMap or TD_GlobalMap.
user_name
Name of user to be granted the map.
WITH GRANT OPTION
The user who is granted the map can grant the map to other users.
role_name
Name of role to be granted the map.
You cannot grant a map WITH GRANT OPTION to a role.
PUBLIC
Privileges are to be inherited by all existing and future Teradata Database users.

Secure Zones and Sparse Maps

Sparse maps can only be granted to users and roles within the same secure zone as the sparse map.