Multiple Privileges with a Single Keyword | Teradata Vantage - Multiple Privileges with a Single Keyword - Analytics Database - Teradata Vantage

SQL Data Control Language

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-07-11
dita:mapPath
sgu1628111251052.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
dvv1472243528022
lifecycle
latest
Product Category
Teradata Vantageā„¢

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