[cx-oracle-users] Setting client_identifier upon connect()

[Dag W. <da...@wi...>]

Hi,

I expect this to not be possible. I am in the situation where a tool 
written in perl is allowed to access the database, but a tool using python 
is not (with the same credentials). When adding a symlink from ./perl to 
/usr/bin/python and using that as the shebang does work.

Given the fact that the client_identifier is so easily circumvented I was 
wondering whether it would be possible to modify the client_identifier 
used upon connect() rather than having to resort to such workarounds.

(Yes, I know changing the ACL is probably the best way forward and is in 
fact formally requested, but due to complex corporate processes this may 
take weeks to get executed anyway...)

I know it is possible to modify the client_identifier once connected, but 
it seems useful to also be able to modify the client_identifier upon 
connect, maybe as an argument to connect().

If it is not currently possible, could it be implemented in cx_Oracle ?

Kind regards,
-- 
-- dag wieers, da...@wi..., http://dag.wieers.com/
-- dagit linux solutions, in...@da..., http://dagit.net/

[Any errors in spelling, tact or fact are transmission errors]