Privileges on named ROW data types
The discretionary access privileges required for operations on
a typed table (a table that is assigned a named ROW data type) are
the same as privileges on any table. For more information, see Table-Level Privileges. The following table
shows which access privileges you need to create a named ROW type.
| Task | Privileges Required |
|---|---|
| Create a named ROW type | Resource privilege on the database |
| Create a named ROW type as a subtype under a supertype | Under privilege on the supertype, as well as the Resource privilege |
For information about Resource and Under privileges and the ALL keyword in the context of privileges, see the GRANT statement.
o find out what privileges exist on a ROW type, check the sysxtdtypes system catalog table for the owner name and the sysxtdtypeauth system catalog table for privileges on the ROW type that might have been granted to users or to roles.
To find out what privileges you have on a given table, check the systabauth system catalog table. For more information on system catalog tables, see the HCL OneDB™ Guide to SQL: Reference.