JDBC realm, how GlassFish knows which group belongs to which user?
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?