Unlock HR Account Oracle Database Tutorial Example

How To Unlock HR Account in Oracle Database Tutorial Example

Run MS-DOS command prompt then copy & paste the below code to unlock HR account in Oracle Database Server Tutorial Example

-- connect as sysdba
-- i am using sqlplus as client. you can use anything as you like.
 

   ALTER USER HR IDENTIFIED BY HR;
   ALTER USER HR ACCOUNT UNLOCK;

      -- HR user and account have been unlocked as sample schema/database in oracle database
      -- is comment in Oracle
      -- in fact it is comment in MSSQL and MySQL as well
   

How To Unlock HR Account in Oracle Database Tutorial Example - Result in MS-DOS SQLPLUS Client Tools

 

Related Tutorial Examples

1. How To Connect Oracle Database AS SYSDBA Example
2. How To Connect Oracle Database Server Tutorial Example
3. How To Show User Tables In Oracle Database Tutorial Example
4. How To Create USER In Oracle Database Tutorial Example
5. How To Drop USER In Oracle Database Tutorial Example
6. MySQL NULLIF() Function Datetime Value Example
7. MySQL Stored Procedure: Batch Salary Increment Example
8. 20 Steps to Learn CakePHP by Example
9. 19 Examples to Learn MySQL
10. UNIX Command Example: File Last Modification Information