Re: Is it possible to stop odbc connections to an oracle database

On Mon, 23 Jan 2006 08:37:03 -0800, hpuxrac wrote:

> Yes you can use the database logon trigger and look at the program
> being used or other parts of the connection information to decide if
> you want the connection ( logon attempt ) to succeed or not.

It *might* be possible to identify the connection based on the USERENV system context setting that iis initialized on session connection.

But that would vary by database version, which ...

For 10gR2, the list is in the SYS_CONTEXT section of the SQL Reference manual at
http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14200/functions165.htm#SQLRF06117

However, I am not sure whether a specific context might tie to ODBC, or if a more obtuse mechanism might be required.

More relevant (to OP) - what is the underlying business problem are you trying to solve? Oracle just might have a solution to the problem, rather than an answer to the question.

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** Top posting [replies] guarantees I won't respond. ***