16.20 - System Level Privileges - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ SQL Data Control Language

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
created_date
March 2019
category
Programming Reference
featnum
B035-1149-162K

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