SQL tutorial 40: DBA Trick, How to drop a user when it is connected to the database

Watch in HD,Dropping a user is easy only when it is not connected to the database what if it is connected. Learn how to drop a user when it is connected to the database as well as when it is not connected, along with the cascade drop and introduction of Startup RESTRICT mode of Oracle database.
-------------------------
Topics cover
1. Drop user when it is not connected to the database
2. Drop user cascade
3. Drop user when it is connected to the database
4. How to kill a session
5. Oracle Start-up Restrict
6. What is Restrict Start-up and why we use it.

Please please LIKE and SHARE my videos it makes me happy.

Links:
Detail Blog (Must Read)
Tutorial 37 Create user using SQL create user statement
Tutorial 39 create user using EM


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

Follow What I am up to as it happens on
Twitter
Instagram
Facebook.
Linkedin.

You can also Email me at

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

[aiu]

Thank you, Manish! I'm from Rio de Janeiro and I appreciate your tutorials! Keep uploading! 

[mohitj]

Hello Manish,
I really appreciate the tremendous job you are doing by posting such nice videos!! Your sessions are very helpful and this was a completely new thing I have learned today.
Just a humble request, could you please upload your videos in the reverse order so that I can watch all of them without stopping. It will be helpful if someone wish to start with Tutorial 1

[rjsashi]

Thank you soo much for the video.. it helped me a lot :)

[everythingforeveryone]

MANISH SHARMA ....TYSM FOR TUTORIALS... I have doubt, can we connect the user without using the cmd..

[nikhilingale]

nice one. I have some queries on db stuffs. Could you please let me know the different ways replication in oracle database.

[khalilnasrallah]

and get fired the next morning lol man you are so hilarious 

[mohammedkapdawala]

Hi Manish, thanks for the tutorials.
I have a doubt, is it possible to retrieve sid and serial# using SQL*PLUS as I'm not able to do the same. It is displaying, no rows selected.

[DeepeshChonkar]

Hello.. this videos are for 1zo-047 or 051 ?

[siddharthtanwar]

hi manish when i m firing select command -i m getting sid and serial# empty.so plz tell me the solution

[antimony]

in the ouput window the column of sid and serial is coming but its not showing anything under it :/

[blackops]

Can you re-sort the video playlist. Video is in the reverse order

[abhaykumar]

Hi manish,
Cant we just revoke 'create session' privilege from user so that it cant reconnect again???? will that work.. if so..please reply all sql queries

[khalilnasrallah]

hi manish . iam trying to drop a user who is not connected by drop user username cascade;
its taking too much time and not executing ... its freaking me out 
help

[reetumasih]

hi manish when iam giving the sid, serial# for the user I want to drop the scrip shows empty sid and serial #. please help

[khalilnasrallah]

MANAISH SHARMA .. THANK YOU VERY MUCH YOUR TUTORIALS ARE BETTER THAN doctors ones .. i just have a doubt about  the user name and the password ... why when we create a new username and password the password is saved in upper case  characters although iam writing it in lower case !?
same issue about the username twhen iam trying to get the sid and serial for a user i got to write the username in uper case even though its in lower case !?!!! 
thank you very much 

[Zhzj-scmn]

Manish brother i need your little help .. can’t drop a user .. I get error (attempt to create, alter or drop and index on temporary table spaces )

[BasitBhat]

Hello Manish,

I dropped the connected user but i forgot to disable the restricted mode and now when i am trying connect through active user accounts i am getting : ORA-12526: TNS:listener: all appropriate instances are in restricted mode.
Please Help.

[DarkWhisperer]

Hello Manish, I need your help... How can I disconnect (kill) 50 users at the same time?