9.7.2.5 CREATE USER

Purpose

The CREATE USER command creates a user.

Syntax

CREATE USER name PASSWORD = *

Usage Notes

• The user name should be unique.

• The username cannot be root, dbmadmin or dbmmonitor. Those are reserved.

• The system prompts for a password for the new user. The password must have 12 to 40 alphanumeric characters or special characters !@#$%^&*() with at least one digit, one lowercase letter, and one uppercase letter. Starting with Oracle Exadata System Software release 18.1.0.0.0, the password can be 8 to 40 characters in length and can also utilize the special characters - and _.

• The new password cannot be the same as the current password for the user.

Example 9-37 Creating a User

DBMCLI> CREATE USER jdoe PASSWORD = *
password: 
Confirm password: password
User jdoe successfully created.