How to use lightweight session in ColdFusion?

[Michael Mekhanoshin]

How to use lightweight session in ColdFusion?

[mpwoodward *TMM*]

Michael Mekhanoshin wrote:

> How to use lightweight session in ColdFusion?

No clue what you mean by "lightweight session"--can you provide more
details?

Matt

--
Matt Woodward
[email]mpwoodward@gmail.com[/email]
Team Macromedia - ColdFusion

[Michael Mekhanoshin]

This is what I mean. Text from Oracle book "JDBC Developer?s Guide and
Reference" follows.

Middle-tier authentication allows one JDBC connection (session) to act as
proxy for
other JDBC connections. A proxy session could be required for one of the
following:if the middle tier does not know the password of the proxy user. This
is done by

first authenticating using:

alter user jeff grant connect through scott with roles role1, role2;
... and so on

[mpwoodward *TMM*]

Michael Mekhanoshin wrote:

> This is what I mean. Text from Oracle book "JDBC Developer?s Guide and
> Reference" follows.
>
> Middle-tier authentication allows one JDBC connection (session) to act as
> proxy for
> other JDBC connections. A proxy session could be required for one of the
> following:if the middle tier does not know the password of the proxy user. This
> is done by
>
> first authenticating using:
>
> alter user jeff grant connect through scott with roles role1, role2;
> ... and so on

General caveat: I know next to nothing about how Oracle deals with
things at this level, so take my response for what it's worth.

On the ColdFusion side of the house, it can use any JDBC driver. As for
the authentication stuff you're talking about, the issue there is that
on the CF side you create a datasource in the CF administrator and that
has a single user name and password. CF then handles the database
connection pooling, but AFAIK it would all be based on that single user
name and password. The proxy situation you're describing ... not sure
how to handle that given the way CF does things. If I'm understanding
what you're describing I'm not sure you can handle it on the CF side.

Matt

--
Matt Woodward
[email]mpwoodward@gmail.com[/email]
Team Macromedia - ColdFusion