17.20 - Teradata Vantage MAPS architecture (MAPS) - Analytics Database - Teradata Vantage

Teradata Vantage™ - Analytics Database Security Administration - 17.20

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-03-07
dita:mapPath
hjo1628096075471.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
zuy1472246340572
To... the user must have the...
create a map CREATE MAP or MAP privilege must be granted to the user or role.
  • Only sparse maps can be created. A sparse map is specific to the secure zone of the creator.
  • The user must be granted the parent contiguous map to create a sparse map with CREATE MAP.
drop a map DROP MAP or MAP privilege.
  • Users and roles within a secure zone cannot drop a sparse map created in another secure zone and cannot drop a contiguous map.
grant/revoke map privileges from users or roles The user must have the map privilege WITH GRANT OPTION to grant or revoke a map privilege.
  • The CREATE MAP and DROP MAP privileges are system-level privileges (they cannot be granted/revoked on an object).
grant/revoke a map
  • A user must be granted the map WITH GRANT OPTION to grant or revoke that map to other users, roles, or PUBLIC. Roles cannot be granted a map WITH GRANT OPTION.
  • The creator of a map is automatically granted the specified map WITH GRANT OPTION, which allows the creator to grant or revoke the created sparse map to users, PUBLIC, and roles.
  • You must be in the same secure zone as the sparse map to grant or revoke it.
  • The GRANT OPTION FOR clause cannot be specified when revoking a map from a role or PUBLIC.
  • If GRANT OPTION FOR is specified, only the WITH GRANT OPTION is revoked.