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

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

144 ratings | 21207 views
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) http://bit.ly/drop-user Tutorial 38 Create user using SQL Developer http://youtu.be/GS4udgR44Ls Tutorial 37 Create user using SQL create user statement http://youtu.be/4QbK2Y-1LZw Tutorial 39 create user using EM http://youtu.be/zGjh-Bb3HrI 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 Follow What I am up to as it happens on Twitter https://twitter.com/rebellionrider Instagram http://instagram.com/rebellionrider Facebook. https://www.facebook.com/imthebhardwaj Linkedin. http://in.linkedin.com/in/mannbhardwaj/ You can also Email me at [email protected] 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 (21)
Abhay Kumar (1 year ago)
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 ??????
Sayan Bakshi (2 years ago)
in the ouput window the column of sid and serial is coming but its not showing anything under it :/
Siddharth Tanwar (2 years ago)
hi manish when i m firing select command -i m getting sid and serial# empty.so plz tell me the solution
MANISH SHARMA ....TYSM FOR TUTORIALS... I have doubt , can we connect the user without using the cmd..
Mohammed Kapdawala (2 years ago)
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.
Reetu Masih (2 years ago)
hi manish when iam giving the sid, serial# for the user I want to drop the scrip shows empty sid and serial #. please help
Serik Myrzayev (11 months ago)
Hi, Reetu. Have you solved this issue? I've just started learning oracle. So, please help me if you have done anything with this. Thanks
Deepesh Chonkar (2 years ago)
Hello.. this videos are for 1zo-047 or 051 ?
Basit Bhat (2 years ago)
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.
Johnny Phan (2 years ago)
Hello Manish, I need your help... How can I disconnect (kill) 50 users at the same time?
simohamed AbouAdam (3 years ago)
Great job  and good explain thank you
Khalil Nasrallah (4 years ago)
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
Khalil Nasrallah (4 years ago)
and get fired the next morning lol man you are so hilarious 
Eduardo Braga (4 years ago)
Thank you, Manish! I'm from Rio de Janeiro and I appreciate your tutorials! Keep uploading! 
Khalil Nasrallah (4 years ago)
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 
Manish Sharma (4 years ago)
Hi +Khalil Nasrallah  Many thanks for all the appreciation, it means a lot to me as it keeps me motivated for doing more such videos. I am sorry but I could not fully understand your question however I have tried to explain the case sensitivity to the best of my knowledge. Regarding the case sensitivity of oracle username and password, usually usernames are not case sensitive but the nature of password’s case sensitivity in oracle 11g depends upon SEC_CASE_SENSITIVE_LOGON initialization parameter which is a new parameter introduced in 11G release. If the value of this parameter is set on true then Database login passwords are case sensitive otherwise Database login passwords are not case sensitive. By default the value of this parameter is set on true. You can check the value of this parameter. For that log on to your database as sys user and then write SHOW PARAMETER SEC_CASE_SENSITIVE_LOGON, I hope this answers your question. However if you have any further questions or doubts then feel free to comment or just drop an email.
mohit joshi (4 years ago)
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
Manish Sharma (4 years ago)
Hello+mohit joshi  I regret any inconvenience. Actually the playlist on this channel is intentionally in reverse order so that people can find the latest videos first. But for your convenience I have created a separate playlist on my other channel where the videos are sorted chronologically. I hope this solves your problem and you are able to enjoy my videos. Please don’t forget to subscribe and Like Thanks Link for the playlist: http://www.youtube.com/playlist?list=PLMlNiWEoh5QqSvF_3wDxXqVA5pPTcuwZQ
Nikhil Ingale (4 years ago)
nice one. I have some queries on db stuffs. Could you please let me know the different ways replication in oracle database.
Olivani Baisheka (4 years ago)
Can you re-sort the video playlist. Video is in the reverse order
Manish Sharma (4 years ago)
Hello +Lucky Luchiano  I regret any inconvenience. Actually the playlist on this channel is intentionally in reverse order so that people can find the latest videos first. But for your convenience I have created a separate playlist on my other channel where the videos are sorted chronologically. I hope this solves your problem and you are able to enjoy my videos. Please don’t forget to subscribe and Like Thanks Link for the playlist: http://www.youtube.com/playlist?list=PLMlNiWEoh5QqSvF_3wDxXqVA5pPTcuwZQ

Would you like to comment?

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