Re: Oracle 9i, authorize or not a client program

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Tue, 19 Oct 2004 19:55:33 +0200
Message-ID: <417554c7$0$29518$626a14ce@news.free.fr>

"cariou" <herve.cariou_at_loto-quebec.com> a écrit dans le message de news:b1551546.0410190634.21d2abb3_at_posting.google.com...
> Hello,
> Is it possible to authorize or not to a client program (module) to
> connect in Oracle 9i (program field from the v$session system
> view...)?
> Is there any native solution (vs. a trigger development)?
> Bye.

You can create a logon trigger, check the program field in v$session et raise_application_error if it is a wrong program but you can't prevent someone to change the program name to an allowed one.

-- 
Regards
Michel Cadot

Received on Tue Oct 19 2004 - 12:55:33 CDT