Spring Security - Third Edition

The CalendarUser authority SQL

You can view the CalendarUser authority mappings in the following code snippet:

    //src/main/resources/database/h2/calendar-authorities.sql    create table calendar_user_authorities (       id bigint identity,       calendar_user bigint not null,       authority varchar(256) not null,    );    -- [e-mail]    insert into calendar_user_authorities(calendar_user, authority)       select id,'ROLE_USER' from calendar_users where       email='[e-mail]';    -- [e-mail]    insert into calendar_user_authorities(calendar_user, authority)       select id,'ROLE_ADMIN' from calendar_users where            email='[e-mail]';    insert into calendar_user_authorities(calendar_user, authority)       select id,'ROLE_USER' from calendar_users where email='[e-mail]'; ...