How can i connect with HR User as it is not existing
684523Feb 11 2009 — edited Mar 19 2009Hi this is Arslan
I need your help in one problem and this problem i am facing from very start
I have installed fresh copy of oracle 10g-2 and when I login with user HR it give following message
Error: ORA-01017 : invalid user name / password; logon denied
after this command i have executed other command
alter user hr account unlock;
then got error ORA- 01918 : USER 'HR' does not exist
again i have executed one more command
alter user hr identified by hr account unlock;
but again receive error that user HR does not exist (error ORA- 01918 : USER 'HR' does not exist)
then i have also check the hr in all_users list with command
select * from all_user
but did not find HR user in this list
can you help me so that i can connect to the hr user, also tell me why this user is not creating with the oracle installation
i have perform all above task with SYS @DBA
Regards
Arslan