Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: SyntaxThe HCL OneDB™ Guide to SQL: Syntax describes the syntax of the statements, data types, expressions, operators, and built-in functions of the HCL OneDB™ dialect of the SQL language.
SQL statementsThis chapter describes the syntax and semantics of SQL statements that are recognized by HCL OneDB™.
CREATE ROW TYPE statementUse the CREATE ROW TYPE statement to create a named ROW type.
Privileges on named ROW data types

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.