Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to unlock hr schema with sql developer

AmbrosianoJan 8 2013 — edited Jan 9 2013
Hi all,

Am trying to unlock hr schema so I can practise the Oracle tutorials.
I did manage to unlock it using the sql*plus with the following command

Alter user hr identified by hr account unlock;

And

Grant create session to hr;

But when I try it on SQL developer, it doesn't work.

The " grant statement" worked but when I try to select * from employees it says " the table or view does not exist"
Pls advice
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 6 2013
Added on Jan 8 2013
3 comments
2,366 views