| SCOTT and HR [message #69682] |
Sat, 16 February 2002 08:36  |
Danielle
Messages: 5
Registered: February 2002
|
Junior Member |
|
|
I am a real newbie at this stuff...
I have ORACLE 9i Personal edition with Windows 2000.
With PL*SQL I can login as SCOTT/tiger and I am able to do select statements on the tables.
Q: How do I access the HR schema?
I tried to login as hr/hr , hr/tiger, hr/manager...
It tells me that the account is locked.
Obviously I don't have the right password.
How do I manage those passwords?
How can I use the tables in the HR schema?
.....
I have a strong background with SQL, VBA, Transact-SQL and now I want to learn PL/SQL.
I got a book for the basic coding stuff but I need a little help managing the ORACLE environment....
My greatest thanks to anyone who is willing to help!
Danielle Paquin
(503) 698-2250 Portland, Oregon
dpaquin@teleport.com
|
|
|
|
| Re: SCOTT and HR [message #69683 is a reply to message #69682] |
Sat, 16 February 2002 17:46  |
Vikas Gupta
Messages: 115
Registered: February 2002
|
Senior Member |
|
|
you must first login as a sysdba, username =
'SYSTEM' and password 'MANAGER' ( I am assuming
that you have installed oracle with default database
configuration and have not changed the system password)
check whether the account exists... fire the following
SQL:
select username from dba_users;
if the username exists, and you do not know the password, just change it by :
alter user "username" identified by "new password"
Regards,
Vikas.
vicky@icenet.net
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
