Privileges 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. This 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.
To 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 IBM Informix Guide to SQL: Reference.
Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]