create_user_statement

The CREATE USER (create_user_statement) SQL statement is supported with a restricted syntax by SAP MaxDB. In the CREATE USER statement, SAP MaxDB does not accept the specification of IDENTIFIED EXTERNALLY, GLOBALLY AS <external_name>, DEFAULT TABLESPACE <tablespace>, TEMPORARY TABLESPACE <tablespace>, QUOTA, and PROFILE <profile>.

The created database user has the RESOURCE status.

SQL Statements: Differences