Re: Denying ODBS connections or restricting those users

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.
Received on Sat Oct 06 2001 - 15:30:08 CDT