CREATE PUBLIC DATABASE LINK remote_connect
CONNECT TO user_id IDENTIFIED BY password
USING 'connect string';


This tells that SQL net opens a session on the database and trys to validate the user_id with the password submitted.
The passowrd stored in the database is the password that is checked and validated.