0

I am trying to connect to a second database via a dblink, but the password has not been included in the dblink. Is there a way you can provide the password dynamically in the dblink when you call it

e.g.

SELECT * FROM TABLE@USERNAME/PASSWORD.DBLINK;

Thanks in advance.

K

1 Answer 1

1

No, there isn't.

enter image description here

Database links created without username and password use authentication data of your current session.

Just create another database link with username + password included.

1
  • Thank for that. We ended up creating the new dblink in the end.
    – KS1
    Commented Mar 21, 2019 at 15:05

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.