Forwarded to dbi-users.
-------- Original Message --------
Subject: DBD::Oracle Schema different than User question
Date: Mon, 12 Nov 2012 13:04:05 -0500
From: Kevin L. Kane <[email protected]>
To: Tim Bunce <[email protected]>, Yanick Champoux <[email protected]>,
"Martin J. Evans" <[email protected]>
Hi all,
I am running into a problem and was planning on modifying my local
DBD::Oracle to add support for a "schema=<mySchema>" construct in the
connect string. Specifically, I want to connect as user X but set
current_schema to Y. Another solution i've toyed with is having a
trigger that switches my schema when I log in but I need to do this
for a lot of different schemas and I will always be the same user. It
seems weird to me that support for this isn't included in DBD::Oracle
currently.
If I do this in a sane way are you at all interested in the patch? Am
I just missing something and this functionality is already there? Or
should this functionality not exist in the first place and why?
Thanks,
Kevin
--
Kevin L. Kane
kevin.kane at gmail.com
