HomeОбразованиеRelated VideosMore From: Manish Sharma

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

302 ratings | 45175 views
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_--- Blog: http://bit.ly/create_user_account Video Tut 4: http://youtu.be/wSqoXRlXDUU How to create a database: http://youtu.be/enFFezPYhCg Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 Amazon Wishlist: http://bit.ly/wishlist-amazon Contacts E-Mail [email protected] Twitter https://twitter.com/rebellionrider Instagram http://instagram.com/rebellionrider Facebook. https://www.facebook.com/imthebhardwaj Linkedin. http://in.linkedin.com/in/mannbhardwaj/ Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com
Html code for embedding videos on your blog
Text Comments (23)
Shaheen Shaikh (20 days ago)
Sir what is tablespace and temporary tablespace plz explain
Deepak Kumar (29 days ago)
What will be the Username for login screen Enterprise Manager?
Sério (4 months ago)
Você é demais :D
R P (5 months ago)
bro thank you so much
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. 00000 - "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.
Kaz Tee (2 years ago)
Trying to create update profile page. Can you please help with this code doesn't work update user (table) set firstname,lastname,address,email,telephone (fields in my table) where 'email' (email it uses to update that particular user account details
shilpa reddy (2 years ago)
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.
abhilash nakka (2 years ago)
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. :)
Johnny Phan (2 years ago)
Hello Manish, Can you do a video for Oracle DBA ADMIN?
durgesh parlewar (2 years ago)
how can solve this problems.sir please help me
durgesh parlewar (2 years ago)
Error starting at line : 1 in command - CREATE USER david IDENTIFIED BY david123 DEFAULT TABLESPACE users TEMPORARY TABLESPACE temp QUOTA 20M ON users ACCOUNT UNLOCK Error report - SQL Error: ORA-01031: insufficient privileges 01031. 00000 - "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
Shreya Agarwal (22 days ago)
@nalinakshee panda It is still not working
Shreya Agarwal (24 days ago)
how to solve this issue?
nalinakshee panda (1 month ago)
I think you were not creating your user in Sys database. I am able to create an user with above query.
Hassan Shuwa (3 years ago)
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
SHEO SHANKAR KUMAR (3 years ago)
what are the six temporary tablespace.?
Sk Noor (3 years ago)
explain very beautifully. thanks Man!
Vikas Pathak (4 years ago)
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..
Joseph Ethan Keenan (4 years ago)
you are great ! you have a great tutorials  thank you so much ! 
tmitchable (4 years ago)
Hi it's interesting tutor, any advise for beginner to take a test for oca
suman bandaru (4 years ago)
Hi Manish,i want to become a Oracle Developer Can you help me on this
suman bandaru (4 years ago)
it was so good
ahsanul haque (4 years ago)
how to db export and import?  ....PLEASE one tutorial.

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.