Spring Security - Third Edition

Adding ACL tables to the H2 database

The first thing we'll need to do is add the required tables and data to support persistent ACL entries in our in-memory H2 database. To do this, we'll add a new SQL DDL file and the corresponding data to our embedded-database declaration in schema.sql. We will break down each of these files later in the chapter.

We have included the following schema.sql file with this chapter's source code, which is based upon the schema files included in the Spring Security reference's Appendix, Additional Reference Material:

src/main/resources/schema.sql-- ACL Schema --create table acl_sid (id bigint generated by default as identity(start with 100) not   null primary key,principal boolean not null,sid varchar_ignorecase(100) ...