Can you explain JDBCRealm?

What is Realm?

A Realm is a "database" of usernames and passwords that identify valid users of a web application (or set of web applications), plus an enumeration of the list of roles associated with each valid user. You can think of roles as similar to groups in Unix-like operating systems, because access to specific web application resources is granted to all users possessing a particular role (rather than enumerating the list of associated usernames). A particular user can have any number of roles associated with their username.

What is JDBCRealm?

JDBCRealm is an implementation of the Tomcat 6 Realm interface that looks up users in a relational database accessed via a JDBC driver.

database structure conforms to the following requirements:

• There must be a table, referenced below as the users table, that contains one row for every valid user that this Realm should recognize.

•     The users table must contain at least two columns (it may contain more if your existing applications required it):


• Username to be recognized by Tomcat when the user logs in.
• Password to be recognized by Tomcat when the user logs in. This value may in cleartext or digested - see below for more information.

•     There must be a table, referenced below as the user roles table, that contains one row for every valid role that is assigned to a particular user. It is legal for a user to have zero, one, or more than one valid role.

•     The user roles table must contain at least two columns (it may contain more if your existing applications required it):

• Username to be recognized by Tomcat (same value as is specified in the users table)
• Role name of a valid role associated with this user.

For more information http://tomcat.apache.org/tomcat-6.0-doc/realm-howto.html#JDBCRealm

Thanks & Regards

-----------------

Chintan Rathod