System-Level Privileges | SQL Data Control Language | Teradata Vantage - 17.05 - System-Level Privileges - Teradata Database

Teradata Vantageā„¢ - SQL Data Control Language

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
17.05
created_date
June 2020
category
Programming Reference
featnum
B035-1149-170K

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