Hi All

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
USING 'GEODB'

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.

Amol