RE : user identification

From: Stephane Faroult <sfaroult_at_oriolecorp.com>
Date: Wed, 18 Oct 2000 11:18:04 +0200
Message-Id: <10653.119607@fatcity.com>

Ed,

    IMHO it's a bad policy to let database links connect to an 'ordinary' account. I find it better to create a dedicated user account, to be considered as a 'bridgehead' for other applications, to grant it the privileges it needs (nothing more) and create if need be private synonyms on this account. It makes things easier to maintain, helps paranoids relax, and would solve your problem at once.   Other things you may want to look for are 'machine' and 'program' (and possibly 'terminal') in V$SESSION which may give you at least useful hints, if not 100% certainty. And you should join my campaign in favour of the DBMS_APPLICATION_INFO package, which makes proper monitoring so much easier ...

Regards,

  Stephane Faroult
  email: sfaroult_at_oriolecorp.com
  Oriole Corporation
  Voice: +44 (0) 7050-696-269
  Fax: +44 (0) 7050-696-449
  Performance Tools & Free Scripts

---

http://www.oriolecorp.com, designed by Oracle DBAs for Oracle DBAs

---

> Subject:
> user identification
> Date:
> Tue, 17 Oct 2000 23:40:57 -0800
> From:
> "Shevtsov, Eduard" <EShevtsov_at_flagship.ru>
> Reply-To:
> ORACLE-L_at_fatcity.com
> Organization:
> Fat City Network Services, San Diego, California
> To:
> Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>
>
> Hi gurus
>
>
> One of my colleagues asked an interesting question and I still don't know
> the answer. How developer (PL/SQL) can distinguish whether user come to
> server via db link or directly?
Received on Wed Oct 18 2000 - 04:18:04 CDT