Multiple Privileges with a Single Keyword | Teradata Vantage - Multiple Privileges with a Single Keyword - Advanced SQL Engine - Teradata Database

SQL Data Control Language

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-24
dita:mapPath
lmb1556233084626.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1149
lifecycle
previous
Product Category
Teradata® Vantage™ NewSQLEngine

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