Re: Public dblink as current_user without ASO - doable?

From: Brian Peasland <oracle_dba_at_peasland.com>
Date: Thu, 17 Oct 2002 20:45:48 GMT
Message-ID: <3DAF217C.FA7C6E79@peasland.com>

I'm not quite sure if it is what you are looking for, but you can create a public db link, and not specify any user in the link definition. When a user attempts to query with this link, it will sign on to the remote db as their current user/pswd. See below:

ORA9I SQL> create public database link other_db using 'heat';

Database link created.

ORA9I SQL> connect dbamon
Enter password:
Connected.
ORA9I SQL> select sysdate from dual_at_other_db;

SYSDATE

---

17-OCT-02 HTH,
Brian

John Bossert wrote:
>
> I'm trying to create a public dblink as "current_user" without Advanced Security
> Option (ASO.) Oracle Support says I can't do it. This is new territory for me,
> and I'm wondering if there _is_ a way to accomplish this. Thanks in advance.
>
> --
> John Bossert
>
> In what concerns you much, do not think that you
> have companions: know that you are alone in the world.
>
> -- Henry David Thoreau
Received on Thu Oct 17 2002 - 15:45:48 CDT