CREATE USER

Purpose

Use this statement to add users to the database.

Prerequisite

You must have the system privilege CREATE USER.

Syntax

create_user::=

Create User

Usage Notes

  • For the user to be able to log in subsequently, the system privilege CREATE SESSION must be granted.
  • For the user name, the same rules as for SQL identifiers apply. However, even with identifiers in quotation marks, no attention is paid to case sensitivity. This means that the usernames "Test", "TEST", and "test" are synonymous. For more information, refer to the SQL Identifier section.
  • A user created will not be automatically associated with a schema.
  • A user can be altered by the ALTER USER command and renamed by using the RENAME command.
  • For information about the database users, refer to the system tables EXA_DBA_USERS, EXA_ALL_USERS, and EXA_USER_USERS.
  • For details about password security (complexity, expiry, locking accounts, refer to the Database Users and Roles and Privileges sections.
  • Users created outside of the SaaS Web Console (for example, using the syntax above) are not managed or visible in the Web Console. These users must be managed manually using SQL Commands.
  • Users created outside of the SaaS Web Console are subject to the same IP access restrictions as users created from the SaaS Web Console. The IP Address of the client must be added to the Allow List before the user can connect to the database.

Examples

CREATE USER user_1 IDENTIFIED BY "h12_xhz";
GRANT CREATE SESSION TO user_1; 

Authentication using password

If you want to authenticate the database user with a password, create a user authenticated by a password. The database checks the user's password when they log in. The password has to be specified as identifier. If you use delimited (quoted) identifiers, then the password is case sensitive. For more information, refer to the SQL Identifier section.

In case of a regular identifier (unquoted) the password will be set to uppercase letters and has to be adjusted for the login.