SQL tutorial 42: How to Unlock user using SQL Developer By Manish Sharma RebellionRider

Key Takeaways

What's up internet? Welcome back once again. I'm Manish from rebellionrider.com. In my previous tutorial, I have shown you the traditional way of unlocking a user using alter user command. And today I will show you how to unlock a user using SQL developer tool. So without further ado, let's jump onto today's SQL tutorial. As I have already mentioned in my previous tutorial that to unlock or to perform any user management task in Oracle database, you either need to have all user system privilege or log on to your database using SIS user with CISDB privileges. Like always, I'm going to log on to my database using SIS user with CISDB privileges. And for that I have already created a connection with SIS user here in my SQL developer by the name of SIS at local host. In my tutorial 38, I have explained how to make connection using SIS user. You can watch that tutorial link is in the description box. So let's connect to our database using this connection. For that simply right click and select the connection and choose connect. After doing this just double click and expand your CIS connection. In my case it's already expanded. This will open up the tree structure as you can see here of all the database objects owned by our SIS user. From all these objects, we have to choose the other users, which is the last one in the list. Now, double click and expand this other users folder. Now, you will be able to see the list of all the users created in your database. Some of them are created by database and some of them are created by you. In my case, most of the users are from Oracle sample schema. By the way, I have done a video series on how to create a user where I explain different ways of creating users. If you want, you can watch them. Links are in the description box. From this list, choose the user which you want to unlock. For the demonstration purpose, I'm going to use user SH as I have never worked with this user and have never unlocked it. So, let's find the user SH. Here it is. Using the steps which I'm going to perform to unlock the SH user, you can unlock any users. Steps are the same. Now, right click the user which is SH in my case and select edit user. This will open up an edit user wizard. Using this edit user wizard, you can change any of the setting of the user. But for this tutorial, we will concentrate on how to unlock this user. If you can see here on the first tab of this wizard, we have three check boxes from which second one is account is locked which by default is checked which indicates that the user is locked and not accessible. To unlock the user, you need to uncheck this box. If you have forgotten the password or you don't know the default password or you are unlocking sample user account for the first time then I highly recommend you to set the password here otherwise you won't be able to login. So I'm going to set the password for SH account as it's a sample user account and I'm unlocking it for the first time and I have no idea what's its default password. A quick tip for you guys. If you are a DBA and your user informs you that his or her account has expired and logged, then let this password expired checkbox remain checked. By doing so, Oracle engine will ask your user to change the password on next login attempt. And this will let your user set his or her desired password for the account. In my case, I am the only user of the account and have already set the password. So, I don't think I need to set the password again. Thus, I will uncheck this password expired checkbox. Now click apply. Successful proceed SQL command. Click okay. And now click close. Means our user is now unlocked. Let's try to login using this SSH user. For that I will again use the command prompt. Now let's log on to our database using the SSH user. Let me quickly show you the user. Here we go. Our account is unlocked and ready for use. Using the same steps which I have shown you in this tutorial, you can unlock any user of your database. Please hit like if you want me to do more such quick and easy to understand tutorial. Hope you find this quick tutorial helpful. I'll be really happy if you hit like on this video and subscribe to my channel. You can follow me on my social media. All the links are in the description box. Signing off for today. This is Manish from Rebellion Rider.