SQL Developer: Create User

In this video, we’ll look at how to create a new user on an Oracle database in SQL Developer.

In an Oracle database, there are a couple of user accounts already created. However, these are system accounts, which have a lot of privileges. This can be dangerous as you (or other users) could do something bad to the database, either accidentally or on purpose.

So, we should create our own users on the Oracle database.

To do this, we can log in as one of the system accounts. I use SQL Developer in this video, but you can do the same thing in SQL*Plus or any other tool.

[vaibhavvyas]

Hi when i run the queries i get this error ORA-65096: invalid common user or role name
65096. - "invalid common user or role name"
*Cause: An attempt was made to create a common user or role with a name
that was not valid for common users or roles. In addition to the
usual rules for user and role names, common user and role names
must consist only of ASCII characters, and must contain the prefix
specified in common_user_prefix parameter.