Your "Using Tomcat 4 Security Realms" is an excellent itroduction to the Realms and their use.
Howerver, there is some confusion to the database tables in your description of the JDBC realm.
First it would be nice under the heading "Defining the Users Database" not to cal the definitions Table 2, Table 3 and so on, where Table 2 describes the first table of the database, Table 3 tdhe second database table...
( To much tables :)
We could live with that though.
The real confusion comes next.
The users table is ok and also it population.
The user_roles table definition is ok, but inconsitent with the populated version, where the column names doesn't match.
Also in the populated table there semm to be roles not found in the roles table.
Som cut&paste errors I belive!
Thank you again for brilliant explanations!
Regards! / Bertil