REVOKE MAP Statement | SQL Data Control Language | Teradata Vantage - 17.05 - REVOKE 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

Revoke existing contiguous or sparse maps from users and roles.

Required Privileges

You must have been granted the map WITH GRANT OPTION to revoke the map from other users, databases, roles, or PUBLIC.

Syntax

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

Syntax Elements

GRANT OPTION FOR
Revoke the ability to grant the map to other users.
Specifying this option only revokes the ability to grant the map to other users.
map_name
Name of existing contiguous or sparse map.
You cannot specify TD_DataDictonaryMap or TD_GlobalMap.
user_name
Name of user for whom the map is to be revoked.
role_name
Name of role for which the map is to be revoked.
PUBLIC
Privileges are to be revoked for all existing and future Teradata Database users.

Secure Zones and Sparse Maps

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