Creating a New User

Create a new user ID.

Prerequisites

Requires the MANAGE ANY USER system privilege.

Task

To create a new user, execute:

CREATE USER userID
IDENTIFIED BY password

Example:

This statement adds user ID Joe to a database with password welcome:

CREATE USER Joe
IDENTIFIED BY welcome