Required Privileges to Create & Use DATASET Schemas | VantageCloud Lake - Privileges Required for Creating and Using Schemas - Teradata Vantage

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

CREATE DATASET SCHEMA Privilege

The CREATE DATASET SCHEMA privilege allows users to create a schema in SYSUDTLIB. This privilege 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 allows users to drop a schema from SYSUDTLIB, and is granted at the database or individual schema level. This 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 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. This privilege does not guarantee the ability to drop a schema.

WITH DATASET SCHEMA Privilege

The WITH DATASET SCHEMA privilege allows users to associate a created schema with a table column, and can be granted at the database- or individual schema-level. This 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 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 DATASET SCHEMA.