HomeОбразованиеRelated VideosMore From: Abbasi Asif

Oracle Database Users / User Management (Simple)

100 ratings | 40665 views
Create, Alter, Drop, Grant Rights, Default Tablespace, Temporary Tablespace, Quota Setup, View Users Information, Lock / Unlock user account select username,account_status,default_tablespace, temporary_tablespace,created from dba_users; create user myuser identified by myuser; alter user myuser quota unlimited on mytbs; alter user myuser quota 100m on mytbs; alter user temporary tablespace temp; alter user myuser default tablespace mytbs; alter user myuser accout unlock; alter user myuser account lock; alter user myuser password expire; alter user myuser identified by youuser; create user myuser identified by myuser default tablespace users temporary tablespace temp quota unlimited on users; grant create session, resource to myuser; grant create session, resource to myuser with grant option; drop user asif; drop user asif cascade;
Html code for embedding videos on your blog
Text Comments (12)
Elisabeta Butoi (1 year ago)
this was very helpful, I was lost trying to create first database,(just couldn't get over user and password error...after installation, I created new user and now it works, thanks a lot:)
ORACLE SUPPORT (1 year ago)
Hi Asif, Its useful and helpful. Hope this may also useful as per real time experiences: https://ora-data.blogspot.in/2017/04/how-a-user-interact-with-an-oracle-database.html
Nagendra kundapur (1 year ago)
If not able to create user in oracle 12c please execute below command and then we will be able to create users. alter session set "_ORACLE_SCRIPT"=true;
Johnny Phan (2 years ago)
Thank you...
Masjedi Aqtash (2 years ago)
Assslamo alaikom sir . please gaive address of any source to teach me . i wanna become a DBA , I live in bangalore .
Ayoob manker (2 years ago)
Thanks and very easy to understand all videos..if have any videos new version on Oracle 12c please upload...
Shabaz Ahmad (3 years ago)
Assalamulaykum bro i am a new user. i want create a user but my system not generated so plz help me . Thanks  
Swapnil Kumbhare (2 years ago)
+Shabaz Ahmad where have you installed the machine?Is it VM
Mano Yessu (3 years ago)
simple and easy to understand. Thank you. 
Vedran Novak (4 years ago)
Thank you very much!
Ⴚhuck Ɲorris (4 years ago)
Really Really helpful :D thank you 
Yoong SinJie (5 years ago)
suck

Would you like to comment?

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