16.20 - GRANT MAP - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ SQL Data Control Language

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
created_date
March 2019
category
Programming Reference
featnum
B035-1149-162K

Purpose

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

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.