Friday, July 10, 2009

Unlocking HR and OE Schema in Oracle Database

We can use SQL * Plus to unlock OE and HR schema come along with Oracle Database later than version 9i as follow;

ALTER USER hr IDENTIFIED BY hr ACCOUNT UNLOCK;
GRANT CONNECT, RESOURCE to hr;

ALTER USER oe IDENTIFIED BY OE ACCOUNT UNLOCK;
GRANT CONNECT, RESOURCE to OE;

Default password for HR is "hr".

No comments:

Post a Comment