EsiaTest006@yandex.ru / 11111111
EsiaTest002@yandex.ru / 11111111
EsiaTest003@yandex.ru / 11111111


INSERT INTO sec.user( id, employee_id, snils, name, surname, patronymic, email, disabled, auth_type, agent_system_id, agential_username ) VALUES ( 14, null, '00000060002', 'Имя002', 'Фамилия002', 'Отчество002', null, false, 'ESIA', null, null );
INSERT INTO sec.user( id, employee_id, snils, name, surname, patronymic, email, disabled, auth_type, agent_system_id, agential_username ) VALUES ( 15, null, '00000060003', 'Имя003', 'Фамилия003', null, null, false, 'ESIA', null, null );

insert into sec.role(name, type_id, code) values ('Полный доступ', 'ORD', 'test_1');

insert into sec.role_permission (role_id, permission_id)
select r.id, p.id
from sec.permission p, sec.role r

insert into sec.user_role (user_id, role_id)
select u.id, r.id
from sec.user u
cross join sec.role r;