1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
|
-- Create users
insert into users(username, password, enabled) values ('gluster','gluster',1);
insert into users(username, password, enabled) values ('guest','guest',1);
-- Assign authorities to users (to be removed after implementing user group functionality)
insert into authorities(username,authority) values ('gluster','ROLE_USER');
insert into authorities(username,authority) values ('gluster','ROLE_ADMIN');
insert into authorities(username,authority) values ('guest','ROLE_USER');
-- Create user groups
insert into groups(group_name) values ('Users');
insert into groups(group_name) values ('Administrators');
-- Add authorities to groups (functionality not yet implemented in code)
insert into group_authorities(group_id, authority) select id,'ROLE_USER' from groups where group_name='Users';
insert into group_authorities(group_id, authority) select id,'ROLE_USER' from groups where group_name='Administrators';
insert into group_authorities(group_id, authority) select id,'ROLE_ADMIN' from groups where group_name='Administrators';
-- Assign group members
insert into group_members(group_id, username) select id,'guest' from groups where group_name='Users';
insert into group_members(group_id, username) select id,'gluster' from groups where group_name='Administrators';
|
