The
SQL statement CREATE USER (create_user_statement) is supported in SAP DB with restricted syntax. In the
CREATE USER_statement, SAP DB does not accept the specification of IDENTIFIED EXTERNALLY, DEFAULT TABLESPACE <tablespace>, TEMPORARY TABLESPACE <tablespace>, QUOTA and PROFILE <profile>.
The created user has RESOURCE status.