List of links:
JBoss:
http://community.jboss.org/wiki/IntegratingOracleVPDandJBoss
EclipseLink:
http://wiki.eclipse.org/EclipseLink/Development/Oracle/ProxyAuthentication
Oracle:
http://download.oracle.com/docs/cd/B19306_01/network.102/b14266/apdvprxy.htm
http://blogs.oracle.com/olaf/2010/04/using_oracle_proxy_authenticat.html
greg
On Nov 6, 2010, at 09:09, noreply_at_java.net wrote:
> [quote=hanodl]
>
> Hi
>
> I need to do my authentication for the user sessions on the database, Thus I
> need to pass through from the session to the database the username and
> password and all access on the database has to be with their own username and
> password, for only certain users will be granted the roles on the database.
>
> Does anyone have an idea how to do it?
>
> [/quote]
>
> Normally Glassfish (like most application servers) will use connection pools
> to provide access to the database. This means that in a typical
> installation all database access is performed by one database user on behalf
> of many application users.
>
> To achieve what you want, you would have to have /n/ connection pools and /n/
> users (i.e. one connection pool per user). Then you would need to write
> code that, at login time, would figure out which connection pool to associate
> with the current user. This is almost certainly not what you want to do.
> But it is possible.
>
> Best,
> Laird
>
>
> --
>
> [Message sent by forum member 'ljnelson']
>
> View Post: http://forums.java.net/node/713377
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe_at_glassfish.dev.java.net
> For additional commands, e-mail: users-help_at_glassfish.dev.java.net
>