No UserRoles issue

[snavjot]

Hi,

I am fairly new to JAAS and have read the article mentioned in sticky post.

I have done all the configuration but I have a table structure like this. In my application, no user can have multiple roles.

Login
code | pass | role

I dont want to create 2 tables just for the sake of creating if i can use same table in both queries.
Can i use the same table in principalsQuery and rolesQuery? As you can see i don't even have something like roleGroup, how would DatabaseServerLoginModule behave in that scenario?

TIA
Navjot Singh

[pnevado]

You may find it useful to have a look to the source code of the class org.jboss.security.auth.spi.DatabaseServerLoginModule. There you will find the degrees of freedom you have as to tables and columns.

[snavjot]

thanks a lot. it did help.

navjot