16.10 - Multiple Privileges with a Single Keyword - Teradata Database

Teradata Database Security Administration

Product
Teradata Database
Release Number
16.10
Release Date
June 2017
Content Type
Administration
Security
Publication ID
B035-1100-161K
Language
English (United States)

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