Privileges | SQL Data Control Language | VantageCloud Lake - Privileges - Teradata Vantage

Teradata® VantageCloud Lake
Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

The following table describes the columns in the privileges table.

Column Description
Privilege Name of privilege.
Abbreviation in System Views Two-letter code used in system views to represent each privilege granted on an 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 Upon creation, a user or database, automatically gets 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 multiple database privileges, there are privileges that 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.

Upon creation, a user does not automatically get privileges on itself.
Group Functional area of privilege.

The following table summarizes information about each privilege.

Privilege Abbreviation in System Views Automatically Granted Explicitly Granted
Creators Created User or Database Creators Created User or Database Privilege Category
Create Compute Group G1 No No No No System-level
Create Compute Profile O1 No No No No System-level
Drop Compute Group G2 No No No No System-level
Drop Compute Profile O2 No No No No System-level
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
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