SQL tutorial 37: How to create NEW USER account using Create User statement in Oracle database

How to create new user accounts using Oracle Create User statement Of Oracle database.
In This tutorial, you will learn how to create a new user account. Brief explanation of Create user statement syntax and an example of creating a new user and You will learn How to grant Create session system privilege to your

----_Links_---

Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage

Contacts
E-Mail
Twitter
Instagram
Facebook.
Linkedin.

Thanks for liking, commenting, sharing and watching more of our videos

[dontvisitthischannel]

when i execute code it give following error. I just type the same code you type.

Error report -
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.

[rubalshrestha]

Hi Manish,
when i execute code it gave me following error. I typed the same code you used.

Error report -
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.

[YK]

you are great ! you have a great tutorials 
thank you so much ! 

[abhilashnakka]

A small typo mistake in your blog. Under step 3, It is showing as "SQL>grant connect session to ironman;". Please modify CONNECT to CREATE.
Thank you for the tutorial. :)

[seemaranisamal]

Thank u for such a grt video it's help me alot

[hrithikrudra]

Sir, are there any videos regarding subqueries or query related with multiple tables??
if not please do make videos on that.

[DarkWhisperer]

Hello Manish, Can you do a video for Oracle DBA ADMIN?

[hatchvikas]

Thank you Manish, This is rely great series.. I gone through till 37 videos, I am new in Oracle.I have some question here ..I am from SQL server  :), There in SQL Server we have multiple Databases and database level user, we can create table in specific Database, I can connect to any one of the Database. Now My question here is how we can create more than one Databases in Oracle and connect as per required?. Now I have Created new Database using DBCA with Name "VikasTest", Now I am restarting my system, how I can connect to this particular Database, I f I go to the command prompt and SQL plus and connect using system I am able to connect but How I can decide/conform that I have connected to my Database called "VikasTest". As we have facility in sql server you can write the USE DatabaseName and connect to specific Database, please guide me if I am missing anything..

[tmitchable]

Hi it's interesting tutor, any advise for beginner to take a test for oca

[sumanbandaru]

Hi Manish, i want to become a Oracle Developer
Can you help me on this

[shilpareddy]

hi manish i have taken course on oracle dba but I'm not satisfied with their explanation. can u make videos on oracle dba please.

[anishamatthias]

I am getting error on creating user. I have created connection with username as sys and in that I have run this query that you mentioned in Oracle 19C. Please help

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.

[ahsanulhaque]

how to db export and import? 
....PLEASE one tutorial.

[hassanshuwa]

Hi! I have got error in create new user account, please help me what should i do, see query bellow

SQL> create user hsn identified by shuwa
2 default tablespace users temporary tablespace temp
3 quota 20M on users
4 account unlock;
create user hsn identified by shuwa
*
ERROR at line 1:
ORA-01031: insufficient privileges

[shaheenshaikh]

Sir what is tablespace and temporary tablespace plz explain

[apka_vlogs]

What will be the Username for login screen Enterprise Manager?

[SHEOSHANKARKUMARultimate]

what are the six temporary tablespace.?

[divyanshuchaudhari]

alter session set "_ORACLE_SCRIPT"=true;

Execute this command first to create a container user, if you get the below error:

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.

[durgeshparlewar]

how can solve this problems.sir please help me

[jennys]

I was able to create my user properly but I got this error message when I tried to connect:
ERROR:
ORA-12560: TNS:protocol adapter error

Warning: You are no longer connected to ORACLE.