Privileges Required for Creating and Using DATASET Schemas | Teradata Vantage - Privileges Required for Creating and Using Schemas - Advanced SQL Engine - Teradata Database

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.

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.

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.

For more information, see Teradata Vantage™ - SQL Data Control Language, B035-1149.