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

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.