Page History

Table of Contents

Overview

The majority of ALTIBASE HDB syntax includes Oracle syntax.

And ALTIBASE HDB syntax is more simple than Oracle's one.

First, we explain example of converting 'create user' statement and then explain considerations about 'create user'.

Example

ORACLE	ALTIBASE HDB	Comments
create user user01 identified by user01 default tablespace user_tbs temporary tablespace temp quota 1g on quota_table password expire profile app_user account lock;	create user user01 identified by user01 default tablespace user_tbs temporary tablespace temp access other_tbs on;	To enable an user to access to multiple tablespaces, ALTIBASE HDB provides access clause. To forbid some user's access to a specific tablespace, set to off;

ORACLE	ALTIBASE HDB	Comments
IDENTIFIED BY \| EXTERNALLY \| GLOBALLY	IDENTIFIED BY	EXTERNALLY \| GLOBALLY not supported
DEFAULT TABLESPACE	DEFAULT TABLESPACE	-
TEMPORARY TABLESPACE	TEMPORARY TABLESPACE	-
QUOTA	-	-
PROFILE	-	-
PASSWORD EXPIRE	-	-
ACCOUNT LOCK \| UNLOCK	-	-
ENABLE EDITIONS	-	-
-	ACCESS tablespace_name ON \| OFF	-

Specify whether the specified tablespace can be used or not by the user.
ACCESS tablespace_name ON : The user can access the specified tablespace.
ACCESS tablespace_name OFF : The user can not access the specified tablespace.

If the user is not explicitly granted the system privilege for the tablespace, no access will be allowed to the specified tablespace.

When the new user is created in ALTIBASE HDB, usually you must grant these privileges. (CREATE privilege is to create or drop objects.)
CREATE SESSION
CREATE TABLE
CREATE SEQUENCE
CREATE SYNONYM
CREATE PROCEDURE
CREATE VIEW
CREATE TRIGGER

Note

Only the SYS user or a user who has GRANT ANY PRIVILEGES can grant all system access privileges to other users.

ALTIBASE HDB does not support ROLE object.

Versions Compared

Old Version 16

New Version Current

Key

Overview

Example