Create New User in Oracle SQL

In this video, we'll learn how to create a new user in Oracle SQL. This is created on Oracle Express for the purpose of my Introduction to Oracle SQL course.

[bryntnmpn]

Where is the file that you said you will provide in this course? I don't see any link provided.

[GagandeepSingh]

Hi, i did exactly like the steps mentioned in video but i am unable to create new connection like you did in last part, please help Error INvalid username/password but i dont think there is any mistake,

[JosipKnezevic]

Hi, I've got an error:

SQL 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 start with C## or c## and consist only of ASCII
characters.
*Action: Specify a valid common user or role name.

After I put c## as a prefix of the new user, everything went fine. I believe this is for a newer version of Oracle SQL than the one you're describing? Btw, awesome job!

[jb.]

Hello, I keep getting this type of error, what does it mean?

Error starting at line : 1 in command -
CREATE USER intro_user IDENTIFIED BY mypassword
Error report -
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.
*Action: Specify a valid common user or role name.

[fatenbayou]

Hello, i keep getting this type of error

Error starting at line 1 in command

CREATE USER OUG IDENTIFIED BY "123"

Error report -

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.

*Action:

Specify a valid common user or role name.

[manishshaw]

I am unable to find the create_user.sql file in yr it is? please help

[anacruz]

Hello!
Currently I have the following error: ORA - 01017 invalid username/password
I've tried everything from creating new users, changing passwords, removing capital letters... but nothing seems to work, can you help me?

[sairamgudla]

I didn't connect to database
Error:-insufficient privileges ani vachindi

[pradnyeshdoshi]

how reslove this error :


Error starting at line : 1 in command -
CREATE USER new_user IDENTIFIED BY mypassword
Error report -
ORA-01031: insufficient privileges
01031. - "insufficient privileges"
*Cause: An attempt was made to perform a database operation without
the necessary privileges.
*Action: Ask your database administrator or designated security
administrator to grant you the necessary privileges

[hadjerrr]

I have error : ORA-01031:insufficient privileges

[TopRanksU]

grant any privilege to batman
Error report -
ORA-00990: missing or invalid privilege
00990. - "missing or invalid privilege"