UDTs & UDMs | Privileges Needed for Database Administration | Teradata Vantage - UDTs and UDMs - Analytics Database - Teradata Vantage

Security Administration

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-11-02
dita:mapPath
hjo1628096075471.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
zuy1472246340572
lifecycle
latest
Product Category
Teradata Vantage™
To... the user must have the...
create, alter, or drop a UDT UDTTYPE is only granted at the database level. This privilege includes all the abilities of UDTUSAGE plus the ability to create, alter, and drop UDTs. Users can also create or drop cast, ordering, or transform properties.

Users with this privilege cannot, however, create methods or drop and replace existing methods.

create, alter, or drop a UDM UDTMETHOD. This privilege includes all the abilities of UDTTYPE plus ability to use, create, drop or alter any UDT and its methods without any restrictions.
use a UDT or UDM in a table or view, and run all associated methods UDTUSAGE. You can grant this privilege at both the database and object level. It is not an automatic privilege and a user must be granted this privilege or acquire it through a role. A user granted UDTUSAGE WITH GRANT OPTION can grant it (optionally also with the WITH GRANT OPTION) to others.

UDTUSAGE allows users to run all SQL statements that reference existing UDTs and their existing methods. It does not permit creation of UDTs, altering the ordering, casting, or transform behavior of existing UDTs, or creating methods.

create or alter a cast operation for a UDT CREATE CAST and REPLACE CAST privileges.