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, the system privilege CREATE SESSION must be granted.

  • User names are restricted by the same rules as SQL identifiers, except that user names are case insensitive even when delimited by quotation marks. This means that the usernames "Test", "TEST", and "test" are synonymous. For more information, see SQL identifier.

  • A user will not be automatically associated with a schema when created .
  • A user can be altered using the ALTER USER command and renamed 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, see Database Users and Roles and Privileges.
  • Users created outside of the SaaS Web Console 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 adress restrictions as users created from the SaaS Web Console. The IP address of the client must be added to the list of allowed addresses in SaaS 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 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, see SQL identifier.

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