Background documentationcreate_user_statement Locate this document in the navigation structure

 

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.