RE: RE : user identification

Hi Stephane, Patrick.

Thank you for your responses

It's a distributed application. The schemas can be installed on a single db or several db. There are some additional modules (you can read 'db schemas') and user has two choices to login to these schemas. First (explicit) way allows user to log in the schema directly using GUI. The second way (implicit for user) allows user to get some additional data from these schemas via db links when he(she) works in the main schema. I can use v$session.program to determine who is who but I would like to know is there another way to determine that session "came" actually via DB link

Thanks again

Ed

> 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?
> >
> > Thanks
> >
> > Ed
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Stephane Faroult
> INET: sfaroult_at_oriolecorp.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access /
> Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
Received on Wed Oct 18 2000 - 05:51:20 CDT