Friday, May 17, 2013

Unlock Database User account and also Alter User's Privileges in Oracle 10g XE using GUI

Step 1: (for Windows) Click on Start-> All programs-> Oracle 10g Express Edition
click on "Go To Database Home Page".



Step 2: In your default Browser, Oracle Database login Screen will pop out then Login with Admin Username and Password.



Step 3:Click on Administration.



Step 4:Click on Database Users.



Step 5:Click on HR or Another Database Users you want to Unlock or Change User Privileges.



Step 6: Select Account Status as "Unlocked" and give password for HR Account and check whatever Privileges you want to give this User and then click "Alter User".



Step 7:User Altered Screen.


ALSO READ Unlock Database User Account in Oracle 10g XE using SQL Command Line

No comments:

Popular Posts