Re: Question About Oracle Security issue.....

I'd be fascinated to know why?

But the solution would be a database trigger such as:

CREATE OR REPLACE TRIGGER logon_trig
AFTER logon ON DATABASE
call log_proc;

where log_proc is a stored procedure that kills the session based upon the values in v$session.

But I must warn you about one thing with a trigger such as this. If the stored procedure becomes invalid no-one is going to log on ... no matter what they do ... until someone goes into Server Manager and either disables or drops the trigger.

Don't even think about writing a trigger like this unless you can get into the database through Server Manager or have someone standing by who can.

Daniel A. Morgan

Richard wrote:

> Hi,
>
> Is there any possible solution to prevent unauthorized client machines
> and/or unauthorized applications to access
> Oracle database, even with valid USER ID and PASSWORD ??
>
> Thanks,
>
> Richard
> richchen_at_ms6.hinet.net
  Received on Thu Apr 05 2001 - 09:15:57 CEST