This content has been marked as final. Show 4 replies
You could try a test like this:
- Create a user on both the local database and the remote database.
- Set the password on the local database to LOCAL_PW and on the remote to REMOTE_PW
- Create a database link to the remote database without credentials (the 'connected user' link)
- Connect to the local database as this test user.
- Query a table (like DUAL) on the remote database via the link. The connection will be unsuccessful.
ORA-01017: invalid username/password; logon denied
ORA-02063: preceding line from [remote database]
- Without disconnecting (but from a different session) change the user's password on the local database to REMOTE_PW. The passwords are now the same on both instances.
- Query a table (like DUAL) on the remote database via the link. The connection will again be unsuccessful. This demonstrates that the connection is not using the password from the local database's dictionary.
- On the remote database, change the user's password to LOCAL_PW. Note that the passwords no longer match.
- Query a table (like DUAL) on the remote database via the link. This time, the connection will be successful, because the credentials that created teh session can be successfully authenticated on the remote database.