Privileges Required for Creating and Using Schemas - Teradata Vantage NewSQL Engine - 16.20

Teradata Vantageā„¢ DATASET Data Type

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1198-162K

The DATASET data type introduces DDL statements, and added three privileges to the current data control language (DCL).

CREATE DATASET SCHEMA Privilege

CREATE DATASET SCHEMA is a privilege that allows users permission to create a schema in SYSUDTLIB. It is granted at the database level only. The privilege is automatically given to the database DBC with a grant option, and must be explicitly granted with or without grant options by DBC to any other users or databases created, or without grant options to any role created.

The following list provides a summary of this privilege:
  • Privilege: CREATE DATASET SCHEMA
  • Abbreviation in System Views: C1
  • Automatically Granted
    • Creators: No
    • Created User or Database: No
  • Explicitly Granted
    • Creators: Yes
    • Created User or Database: Yes
    • Privilege Category: Dataset Schema

DROP DATASET SCHEMA Privilege

The DROP DATASET SCHEMA privilege gives users permission to drop a schema from SYSUDTLIB, and is granted at the database- or individual schema-level. It is automatically given to the database DBC with a grant option, and must be explicitly granted with or without grant options by DBC to any users or databases created or without grant options to any role created. The schema creator is automatically granted this privilege with grant option on the created schema. Note that possession of this privilege does not guarantee the ability to drop a schema.

The following list provides a summary of this privilege:
  • Privilege: DROP DATASET SCHEMA
  • Abbreviation in System Views: D1
  • Automatically Granted
    • Creators: Yes
    • Created User or Database: No
  • Explicitly Granted
    • Creators: Yes
    • Created User or Database: Yes
    • Privilege Category: Dataset Schema

WITH DATASET SCHEMA Privilege

The WITH DATASET SCHEMA privilege gives users permission to associate a created schema with a table column, and can be granted at the database- or individual schema-level. It is automatically given to the database DBC with a grant option, and must be explicitly granted with or without grant options by DBC to any users or databases created or without grant options to any role created. The schema creator is automatically granted this privilege with grant option on the created schema.

The following list provides a summary of this privilege:
  • Privilege: WITH DATASET SCHEMA
  • Abbreviation in System Views: W1
  • Automatically Granted
    • Creators: Yes
    • Created User or Database: No
  • Explicitly Granted
    • Creators: Yes
    • Created User or Database: Yes
    • Privilege Category: Dataset Schema

For more information, see Teradata Vantageā„¢ SQL Data Control Language, B035-1149.