I have recently configured security for my application and in the process followed the example in Chapter 9 of the Getting Started Guide. There appears to be an error in what is described for the default database schema as described in the footnote on page 57. In describing the default schema for the "Roles" table it lists "Role" as a column name. However "Role" is a reserved word in SQL and can't be used as a column name. If this is the case (my DBA assures me that it is) then how can this be the default schema used by JBoss ? My guess is that this footnote is in error, and the "Roles" table schema actually uses another column name. Can anyone confirm this ?
This schema works fine with the hsqldb shipped with jboss so what is/is not allowed is dependent on the database. Alter the column names to fit your db.
CREATE TABLE Principals (PrincipalID VARCHAR(64) PRIMARY KEY, Password VARCHAR(64) ); CREATE TABLE Roles (PrincipalID VARCHAR(64), Role VARCHAR(64), RoleGroup VARCHAR(64) );