Privileges | SQL Data Control Language | Teradata Vantage - Privileges - Advanced SQL Engine - Teradata Database

SQL Data Control Language

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
sqd1591723147563.ditamap
dita:ditavalPath
sqd1591723147563.ditaval
dita:id
B035-1149
lifecycle
previous
Product Category
Teradata® Vantage™ NewSQLEngine

Below is a description of each of the columns in the privileges table that follows:

Column Description
Privilege Name of privilege.
Abbreviation in System Views Two-letter code used in system views to represent each privilege granted on a particular object.
The AccessRight column in the following views lists privileges for users and roles:
  • DBC.AllRightsV
  • DBC.UserGrantedRightsV
  • DBC.UserRightsV
  • DBC.AllRoleRightsV
  • DBC.UserRoleRightsV
Automatically Granted: Creators When you create a user or database, the system automatically grants you privileges on the created database or user.
Automatically Granted: Created User or Database When you create a user or database, it automatically gets certain privileges on itself.
Explicitly Granted: Creators When you create a user, you do not automatically receive certain privileges on the user.
Explicitly Granted: Created User or Database Although the system automatically grants many database privileges, some privileges are only available to users if you explicitly grant them. You must have the WITH GRANT OPTION privilege on these privileges before you can grant them.

When you create a user, it does not automatically get certain privileges on itself.

Group Functional area of privilege.

The table below lists information about each of the privileges.

Privilege Abbreviation in System Views Automatically Granted Explicitly Granted
Creators Created User or Database Creators Created User or Database Privilege Category
ABORT SESSION or ABORTSESSION AS No No Yes Yes Monitor
ALTER EXTERNAL PROCEDURE AE No No Yes Yes  
ALTER FUNCTION AF No No Yes Yes  
ALTER PROCEDURE AP No No Yes Yes  
ANY AN Yes Yes No No Indicates a HELP or SHOW statement for which at least one privilege, but no specific privilege, is required.
CHECKPOINT CP Yes Yes No No  
CONNECT THROUGH   No No Yes Yes Trusted session-related
CONSTRAINT ASSIGNMENT SA No No Yes Yes System-level
CONSTRAINT DEFINITION SD No No Yes Yes System-level
CREATE AUTHORIZATION CA Yes Yes No No  
CREATE DATABASE CD Yes No No Yes  
CREATE DATASET SCHEMA C1 No No Yes Yes Dataset Schema
CREATE EXTERNAL PROCEDURE CE No No Yes Yes  
CREATE FUNCTION CF No No Yes Yes  
CREATE GLOP GC No No Yes Yes Global and Persistent (GLOP) Data
CREATE MACRO CM Yes Yes No No  
CREATE MAP MC No No Yes Yes System-level
CREATE OWNER PROCEDURE OP No No Yes Yes  
CREATE PROCEDURE PC No No Yes Yes  
CREATE PROFILE CO No No Yes Yes System-level
CREATE ROLE CR No No Yes Yes System-level
CREATE SERVER CS No No Yes Yes  
CREATE TABLE CT Yes Yes No No  
CREATE TRIGGER CG Yes Yes No No  
CREATE USER CU Yes No No Yes  
CREATE VIEW CV Yes Yes No No  
CREATE ZONE CZ No No Yes Yes System-level
CTCONTROL TH No No Yes Yes Trusted session-related
DELETE D Yes Yes No No  
DROP AUTHORIZATION DA Yes Yes No No  
DROP DATABASE DD Yes No No Yes  
DROP DATASET SCHEMA D1 Yes No Yes Yes Dataset Schema
DROP FUNCTION DF Yes Yes No No  
DROP GLOP GD No No Yes Yes Global and Persistent (GLOP) Data
DROP MACRO DM Yes Yes No No  
DROP MAP MD No No Yes Yes System-level
DROP PROCEDURE PD Yes Yes No No  
DROP PROFILE DO No No Yes Yes System-level
DROP ROLE DR No No Yes Yes System-level
DROP SERVER DS No No Yes Yes  
DROP TABLE DT Yes Yes No No  
DROP TRIGGER DG Yes Yes No No  
DROP USER DU Yes No No Yes  
DROP VIEW DV Yes Yes No No  
DROP ZONE DZ No No Yes Yes System-level
DUMP DP Yes Yes No No  
EXECUTE E Yes Yes No No  
EXECUTE FUNCTION EF No No Yes Yes  
EXECUTE PROCEDURE PE No No Yes Yes  
GLOP MEMBER GM No No Yes Yes Global and Persistent (GLOP) Data
INDEX IX No No Yes Yes Table-level
INSERT I Yes Yes No No  
MONITOR RESOURCE or MONRESOURCE MR No No Yes Yes Monitor
MONITOR SESSION or MONSESSION MS No No Yes Yes Monitor
NONTEMPORAL NT No No Yes Yes Temporal
OVERRIDE DELETE OD No No Yes Yes Security Constraint Override
OVERRIDE DUMP OA No No Yes Yes Security Constraint Override
OVERRIDE INSERT OI No No Yes Yes Security Constraint Override
OVERRIDE RESTORE OR No No Yes Yes Security Constraint Override
OVERRIDE SELECT OS No No Yes Yes Security Constraint Override
OVERRIDE UPDATE OU No No Yes Yes Security Constraint Override
REFERENCES RF No No Yes Yes Table-level
RESTORE RS Yes Yes No No  
RETRIEVE/SELECT R Yes Yes No No  
SET RESOURCE RATE or SETRESRATE SR No No Yes Yes Monitor
SET SESSION RATE or SETSESSRATE SS No No Yes Yes Monitor
SHOW SH No No Yes Yes  
STATISTICS ST Yes Yes No No Also for creators of tables
UDT METHOD or UDTMETHOD UM No No Yes Yes UDT
UDT TYPE or UDTTYPE UT No No Yes Yes UDT
UDT USAGE or UDTUSAGE UU No No Yes Yes UDT
UPDATE U Yes Yes No No  
WITH DATASET SCHEMA W1 Yes No Yes Yes Dataset Schema
ZONE OVERRIDE ZO No No No No System-level