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 SCHEMA statementUse the CREATE SCHEMA statement to issue a block of data definition language (DDL) and GRANT statements as a unit.
Creating Database Objects Within CREATE SCHEMAAll database objects that a CREATE SCHEMA statement creates are owned by user, even if you do not explicitly name each database object. If you are the DBA, you can create database objects for another user. If you are not the DBA, specifying an owner other than yourself results in an error message.

Creating Database Objects Within CREATE SCHEMA

All database objects that a CREATE SCHEMA statement creates are owned by user, even if you do not explicitly name each database object. If you are the DBA, you can create database objects for another user. If you are not the DBA, specifying an owner other than yourself results in an error message.

Suppose that user oswald holds the DBA access privilege and issues the following CREATE SCHEMA statement:

CREATE SCHEMA AUTHORIZATION hilda
   CREATE ROW TYPE IF NOT EXISTS 
      hildago (field1 INT,
               field2 CHAR(18) NOT NULL,
               field3 DATE);

The owner of this named ROW type is the user whose authorization identifier is hilda, rather than user oswald who issued the CREATE ROW TYPE statement. This example would fail if user oswald does not hold the DBA privilege.

You can only grant access privileges with the CREATE SCHEMA statement; you cannot use CREATE SCHEMA to revoke or to drop access privileges.

If you create a database object or use the GRANT statement outside a CREATE SCHEMA statement, you receive warnings if you use the -ansi flag or set DBANSIWARN.