Tuesday, July 10, 2007

Unlock the Teaching account


Unlock the Teaching account

The HR user is for accout for teaching. IN any stydy material from oracle is containning the example of the built-in table of this user.

------By default password------

username:-HR

password:-6399F3B38EDF3288

------Above is collected from this command------

sql>select * from dba_user where username='hr';

-----------------------------------------------------------------------------------------------

the user is generally locked and the account is set to expired.

to unlock this account give the command.

sql>alter user hr identified by arka account unlock;

-----------------------------------------------------------------------------------------------

Now you can see all the tables in the account like employee table

sql>Select * from tab;

sql>select * from employee;

No comments: