Re: Denying ODBS connections or restricting those users

From: Ban Spam <ban-spam_at_operamail.com>
Date: Sat, 06 Oct 2001 23:54:18 GMT
Message-ID: <Xns9132ABF6A5A74SunnySD@24.0.3.73>

jerra_at_aland.net (Jerra) wrote in
news:3f495dc1.0110061230.59f7c626_at_posting.google.com:

> Read that there is no support for DDL in system triggers except Alter
> Table(?). This seems to be something that cannot be solved in a nice
> way....
>
> Thanks anyway!
>
> /Jerra
>

>> With 8i+ which supports logon triggers, you could write
>> a logon trigger that checks V$SESSION.PROGRAM. If the
>> program is NOT on the approved white-list, terminate the session.

Did you consider using "dynamic SQL"?

You need to be smarter than the equipment you are working on/with.

HTH & YMMV! Received on Sat Oct 06 2001 - 18:54:18 CDT