Fwd: DBD::Oracle Schema different than User question

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