How to use the CREATE USER command to create a new username in Oracle

How do I create a new username and password for the database like a simultaneous user or co-user?

    Requires Free Membership to View

The CREATE USER command is used to create a user. It is similar to the following:

CREATE USER username IDENTIFIED BY password;

Please refer to the following for more details on all the options for the CREATE USER command.

Have a question for Brian Peasland? Send an e-mail to



This was first published in February 2010

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: