| Goal | Privileges User Needs |
|---|---|
| Create, alter, or drop 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 new methods or drop and replace existing methods. |
| Create, alter, or drop 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 UDT or UDM in table or view and run all associated methods | UDTUSAGE. You can grant this privilege at database and object level. User must be granted this privilege or acquire privilege through role. A user granted UDTUSAGE WITH GRANT OPTION can grant privilege to others. UDTUSAGE allows users to run all SQL statements that reference existing UDTs and their existing methods. UDTUSAGE does not allow creation of new UDTs, altering ordering, casting, or transform behavior of existing UDTs, or creating new methods. |
| Create or alter cast operation for UDT | CREATE CAST and REPLACE CAST privileges. |