I do the same.
The end of the dblink is a specific user with limited
rights.
- Stephane Faroult <sfaroult_at_oriolecorp.com> a
écrit : > 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
> also send the HELP command for other information
> (like subscribing).
Stephane Paquette
DBA Oracle
stephane_paquette_at_yahoo.com
Received on Wed Oct 18 2000 - 08:20:25 CDT
