...
User SELECT SQL: select username, password from
APP.
users where username=?
Group SELECT SQL: select username, password groupname from
APP.
groups where username=?
Note that APP is the default schema for the embedded Derby database and need to precede the table in the SQL statement. This statements are likely to be different from one database to another, for instance this procedure was also tested with DB2, the SQL statements used were:
User SELECT SQL: select username, password from users where username=?
Group SELECT SQL: select username, groupname from groups where username=?
Security realm for using with database authentication.
...