16.20 - Multiple Privileges with a Single Keyword - 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

Teradata Database 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 execute 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 execute 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