HOW TO UNLOCK HR USER in Oracle 11g | How to Unlock HR Schema in Oracle 11g | Oracle Tutorials

you can run the application and after running the application you can start making a connection with your oracle sql developer and now first of all we will be login to the system administrator or a sys user okay so since user is a system administrator and we are going to create a uh so first click on the plus sign on the left hand panel just type name as cis as cis dba means you wanted to log in as a css dba but the password says as says dba put the password which you have given for the installation if you don't know how to install oracle 11g you can refer the above link so just put the password which you have given for the root user or the system user and make sure you come in the service name and just you put capital xe okay xc means express edition and just click on test if you click on test and you get success in the last means here so that means you have successfully created a connection with the system administrative user so this is the user who will be responsible to create a new user because it has all the permission it has all the privileges so click on connect and you see the connection has been established now you have to click on this system so our worksheet will be open and in this worksheet we will be writing down some commands to see whether the user has been the hr user or the hr schema has been unlocked or not so for the first thing you have to say alter user hr account unlock this is the first command that you have to run that is alter user hr account unlock and run it so you see at the bottom you get alter user hr account altered so that means we have unlocked the hr user successfully after that now the one thing is how to run this particular command if you are interested to run this command you have to select this whole line and you can click on this screen icon okay otherwise you can also use a shortcut key like put your cursor on the same line and put ctrl enter so it will execute this particular command again now you need to set the password for the hr user that you have created now to set the password so just again run a command alter user hr so i am interested to alter the hr user then say identified by hr so means you have to set the password of this hr user to hr only so the user name is hr and the password will be hr and run this command using the control enter and you see the user hr account has been altered now we have to create a connection for this hr user and now we can login to this hr for looking at the demo schema that we have so give a name as any name that you like hr user make sure the username is hr and the password is again in hr then go on the service name and again put capital xc and click on test so you see success so that means you have successfully unlocked the hr schema and you have set the password for it and in the last click on connect so when you click on connect every time a new worksheet will be created and you can see the hr connection has been established and if you click on the plus sign you can see the lot of tables the filters the view that you have on the table so you see i have some dummy tables i have some database so everything is there what are the views that i have created already that are present so might be in your system the views and other things might not be present but you can create it later on so that is how we create the connection we we unlock the hr user and we made the connection with it now in case you are interested to run a query so you can run any query to see whether the things are working fine so you can select all the data from the employees table to see whether the employees table is present or not and make sure you get the output so this is how we unlock the user if you think okay if you have any issues you can put that issues in the comment and i hope everyone has enjoyed this video you

Channel: REGex Software

Views: 7,650

Keywords: HOW TO UNLOCK HR USER in Oracle 11g, oracle hr user, Unlock HR Schema, How to Unlock HR User in Oracle Database 11g Express Edition, how to install hr schema in oracle database, how to install hr schema in oracle 11g, unlock the oracle Hr Schema, how to create hr connection in sql developer, oracle tutorial, oracle database, hr, hr user, hr schema in oracle 11g, yt:cc=on, how to install sql developer, oracle tutorial for beginners, oracle hr user guide, oracle hr user password

Id: nBbeMWyLWxM

Length: 4min 47sec (287 seconds)

Published: Sun Apr 03 2022