16.20 - REVOKE 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

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

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.