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

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.