| ORA-01017: invalid username/password, depending on db [message #384256] |
Tue, 03 February 2009 00:47  |
filiprus
Messages: 9
Registered: February 2009
Location: Singapore
|
Junior Member |
|
|
Hi there,
I've spent a few days looking for an answer on the internet, so although this may seem like a simple query, please do not accuse me of taking the easy way out by posting here.
Apart from the main database "orcl", I've created a second one called "devel". I've also created a user "testusr".
The problem is the following:
sqlplus testusr/testusr@orcl
works fine
sqlplus testusr/testusr@devel
gives me ORA-01017: invalid username/password; logon denied
1) I really don't see any security setting that gives testusr access in particular to devel, and don't see why the credentials would not be the same
2) I don't think the bad login attempt is logged anywhere, excep twhen I turn audit on - which I did - but it still doesn't help me further as it just stores the error code (1017).
SO the question is, why does "sqlplus testusr/testusr@devel" not work?
Your help will be greatly appreciated.
Regards,
FR
|
|
|
|
|
|
| Re: ORA-01017: invalid username/password, depending on db [message #384271 is a reply to message #384265] |
Tue, 03 February 2009 01:38  |
filiprus
Messages: 9
Registered: February 2009
Location: Singapore
|
Junior Member |
|
|
Hey Michel,
I don't have my tnsnames and other config files with me right now.
But the bottom line is that with the same user credentials I can login to @orcl, and I can not to @devel (get invalid user/password). Why would there ever be a difference in user access between databases? Where is this controlled or what else could be wrong here?
Thanks,
FR
|
|
|
|
|
|
|
|
|
|
| Re: ORA-01017: invalid username/password, depending on db [message #384289 is a reply to message #384256] |
Tue, 03 February 2009 02:59 |
filiprus
Messages: 9
Registered: February 2009
Location: Singapore
|
Junior Member |
|
|
Ok, thanks Michel.
Can anyone else help with this?
I think I explained the problem quite well. User crednetials work on ORCL database but not on another db - both running on the same server obviously.
From what I understand there is only one user/pass table, which is used for authentications for all databases. In this case something else appears to be different. Any ideas?
Thanks,
FR
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
