SSO Authentication against Oracle Database

[edgoquist]

Is this possible? Can I use SSO with my existing database authentication. The stuff I've seen so far only shows LDAP examples.

here's a snippet of my login-config to give a better picture of what i'm trying to do:

<application-policy name="myname">

<login-module code="org.jboss.security.auth.spi.DatabaseServerLoginModule" flag="required">
<module-option name="dsJndiName">java:/dsname</module-option>
<module-option name="principalsQuery">select passwd from ...</module-option>
<module-option name="rolesQuery">select role from ...</module-option>

</login-module>

</application-policy>

I don't want to change anything there.
thanks. -e.

[wolfgangknauf]

Sure, you just have to take care that "java:/dsname" points to a DataSource to your Oracle.

Probably this does not help much, but your question was quite general ;-).

Best regards

Wolfgang

[edgoquist]

Thank you. yes, the question was very general as was your answer and that's just the way I wanted it. I haven't really done much work to figure out how to get sso going and just wanted to make sure it was possible

thanks. -e.