Hi Hez
On 26 March 2011 11:23, hezjing <hezjing_at_gmail.com> wrote:
> Hi
>
> I'm trying to create a JDBC realm in GlassFish 3.1.
>
> I have created an user table (with username and password columns) and a
> group table (with just a name column).
>
> I'm wondering how GlassFish can tell which groups assigned to which user?
> Isn't there should be one table storing these user group assignment?
>
>
> Appreciate your advice, thank you!
>
This is one of the blogs I always look at
http://blogs.sun.com/swchan/entry/jdbcrealm_in_glassfish_with_mysql
The user ID is a foreign key in the group table.
Hope this helps
Richard.