17.05 - Revoking UDT-Related Privileges - Teradata Database

Teradata Vantage™ - SQL Data Control Language

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
17.05
created_date
June 2020
category
Programming Reference
featnum
B035-1149-170K

The following examples provide a representative sample of how to revoke UDT-related privileges:

     REVOKE UDTUSAGE
     ON SYSUDTLIB
     FROM tester1;

     REVOKE UDTMETHOD
     ON SYSUDTLIB
     FROM User_DBA;

     REVOKE UDTMETHOD
     ON SYSUDTLIB
     FROM Developer_Role;

For More Information

See the following topics for information about UDT-related privileges: