System-Level Privileges | SQL Data Control Language | Teradata Vantage - System-Level Privileges - 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

System-level privileges apply system-wide and cannot be defined on a database object. Generally, these privileges are used by administrators.

The system-level privileges are as follows:
  • CONSTRAINT ASSIGNMENT
  • CONSTRAINT DEFINITION
  • CREATE MAP
  • CREATE ROLE
  • CREATE PROFILE
  • CREATE ZONE
  • CTCONTROL
  • DROP MAP
  • DROP ROLE
  • DROP PROFILE
  • DROP ZONE
  • MONITOR
    • ABORTSESSION
    • MONRESOURCE
    • MONSESSION
    • SETRESRATE
    • SETSESSRATE
  • ZONE OVERRIDE