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 TABLE statementUse the CREATE TABLE statement to create a new permanent table in the current database.
OF TYPE ClauseUse the OF TYPE clause to create a typed table for an object-relational database. A typed table is a table in which every row is an object of the named ROW data type that you specify in this clause.
Access Privileges on TablesThe discretionary access privileges on a table describe both who can access the information in the table and who can create new tables.

Access Privileges on Tables

The discretionary access privileges on a table describe both who can access the information in the table and who can create new tables.

For more information about discretionary access privileges, see the description of the GRANT statement statement.

In an ANSI-compliant database, no default table-level privileges exist. You must grant these privileges explicitly.

Setting the environment variable NODEFDAC to yes prevents default privileges from being granted to PUBLIC on new tables in a database that is not ANSI compliant, as described in the HCL OneDB™ Guide to SQL: Reference.

Important: Enabling NODEFDAC withholds default table access or routine access privileges from PUBLIC when the object is registered in the system catalog, but the NODEFDAC setting cannot prevent the PUBLIC group from being granted the same privileges by a user who holds the necessary access privileges on the new table or on the new UDR.

For more information about discretionary access privileges, see the HCL OneDB Guide to SQL: Tutorial.