Multiple Privileges with a Single Keyword | VantageCloud Lake - Multiple Privileges with a Single Keyword - Teradata Vantage

Teradata® VantageCloud Lake
Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
Language
English (United States)
Last Update
2024-04-03
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

Vantage provides a special category of keywords that you can use to grant multiple privileges. For example, the following request uses the keyword DATABASE to grant both the CREATE DATABASE and DROP DATABASE privileges on user_name1 to user_name2:

GRANT DATABASE ON  user_name1  TO  user_name2;

The following keyword grants enter multiple privileges for the grantee in the DBC.AccessRights table:

Keyword Included Privileges
ALL All implicit and explicit object privileges that the grantor owns, and on which the grantor has WITH GRANT OPTION, on the object specified in the ON clause.
CHECKPOINT The privilege to run the:
  • CHECKPOINT SQL statement.
  • HUT CHECKPOINT command.
DATABASE
  • CREATE DATABASE
  • DROP DATABASE
FUNCTION
  • CREATE FUNCTION
  • DROP FUNCTION
GLOP
  • CREATE GLOP
  • DROP GLOP
INDEX
  • CREATE INDEX
  • DROP INDEX
MACRO
  • CREATE MACRO
  • DROP MACRO
MAP
  • CREATE MAP
  • DROP MAP
OVERRIDE
  • OVERRIDE INSERT
  • OVERRIDE SELECT
  • OVERRIDE UPDATE
  • OVERRIDE DELETE
  • OVERRIDE DUMP
  • OVERRIDE RESTORE
PROCEDURE
  • CREATE PROCEDURE
  • DROP PROCEDURE
PROFILE
  • CREATE PROFILE
  • DROP PROFILE
RESTORE The privilege to run the following HUT commands:
  • DELETE JOURNAL
  • ROLLBACK
  • ROLLFORWARD
ROLE
  • CREATE ROLE
  • DROP ROLE
SHOW Only the following variations of the HELP and SHOW commands:
  • HELP database_object
  • SHOW database_object
TABLE
  • CREATE TABLE
  • DROP TABLE
TRIGGER
  • CREATE TRIGGER
  • DROP TRIGGER
USER
  • CREATE USER
  • DROP USER
If the target of a GRANT USER is a user, then USER confers CREATE and DROP privileges. If the target of a GRANT USER is a database, then USER confers the privilege to CREATE users within the database.
VIEW
  • CREATE VIEW
  • DROP VIEW
ZONE
  • CREATE ZONE
  • DROP ZONE