I have created a privte db alink on scott user of my local machine using 'CURRENT_USER' clause.
CREATE DATABASE LINK GDB
CONNECT TO CURRENT_USER
When from SCOTT I run 'select * from emp@gdb' then it creates problem. It gives the error above (in sbject line)
The link works fine I remove the CONNECT TO line.
Whats the problem with the CONNECT_USER clause here. One link on Oracle club says that it may be because of you have installed Advance Security Option. Does it like that? How then I will use CURRENT_USER clause.
Refer Doc #158365.1 on metalink.
You can't have the CURRENT_USER clause in a dblink if the db where the link resides uses the ASO.