Privileges on Distinct Types

To create a distinct type, you must have the Resource privilege on the database. When you create the distinct type, only you, the owner, have Usage privilege on this type. Use the GRANT or REVOKE statements to grant or revoke Usage privilege to other database users.

To find out what privileges exist on a particular type, check the sysxtdtypes system catalog table for the owner name and the sysxtdtypeauth system catalog table for additional data type privileges that might have been granted. For more information on system catalog tables, see the HCL OneDB™ Guide to SQL: Reference.

The DB-Access utility can also display privileges on distinct types.