delete from sec_groups;
delete from sec_jt_groups_groups;
delete from sec_jt_groups_roles;
delete from sec_jt_roles_privileges;
delete from sec_jt_roles_secobjects;
delete from sec_jt_users_groups;
delete from sec_jt_users_roles;
delete from sec_privileges;
delete from sec_rights;
delete from sec_roles;
delete from sec_securable_objects;
delete from sec_secured_object_types;
delete from sec_secured_objects;


--
--

SET escape_string_warning = off;


--
-- Data for Name: sec_groups; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY sec_groups (id) FROM stdin;
2
10
\.


--
-- Data for Name: sec_jt_groups_groups; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY sec_jt_groups_groups (fk_groups_member, fk_groups) FROM stdin;
\.


--
-- Data for Name: sec_jt_groups_roles; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY sec_jt_groups_roles (fk_groups, fk_roles) FROM stdin;
2	3
10	9
\.


--
-- Data for Name: sec_jt_roles_privileges; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY sec_jt_roles_privileges (fk_roles, fk_privileges, "constraints") FROM stdin;
3	1	\N
3	2	\N
3	3	\N
3	4	\N
3	5	\N
\.


--
-- Data for Name: sec_jt_roles_secobjects; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY sec_jt_roles_secobjects (fk_roles, fk_securable_objects, fk_rights, "constraints") FROM stdin;
3	2	8	\N
3	4	3	\N
3	4	6	\N
3	4	8	\N
3	6	3	\N
3	6	6	\N
3	6	8	\N
3	8	3	\N
3	8	6	\N
3	8	8	\N
3	9	3	\N
3	9	6	\N
3	9	8	\N
3	10	3	\N
3	10	6	\N
3	10	8	\N
3	14	3	\N
3	14	6	\N
3	14	8	\N
3	15	3	\N
3	15	6	\N
3	15	8	\N
9	6	9	\N
9	6	10	\N
9	6	11	\N
9	14	9	\N
9	14	10	\N
9	14	11	\N
9	8	3	\N
9	8	4	\N
9	8	6	\N
9	8	13	\N
9	8	14	\N
9	15	3	\N
9	15	4	\N
9	15	6	\N
9	15	13	\N
9	15	14	\N
\.


--
-- Data for Name: sec_jt_users_groups; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY sec_jt_users_groups (fk_users, fk_groups) FROM stdin;
1	2
4	10
\.


--
-- Data for Name: sec_jt_users_roles; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY sec_jt_users_roles (fk_users, fk_roles) FROM stdin;
\.


--
-- Data for Name: sec_privileges; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY sec_privileges (id, name) FROM stdin;
1	write
2	adduser
3	addgroup
4	addrole
5	addobject
\.


--
-- Data for Name: sec_rights; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY sec_rights (id, name) FROM stdin;
1	access
2	query
3	delete
1003	delete_Response
4	insert
1004	insert_Response
5	execute
6	update
1006	update_Response
7	view
8	grant
9	GetMap
1009	GetMap_Response
10	GetFeatureInfo
1010	GetFeatureInfo_Response
11	GetLegendGraphic
1011	GetLegendGraphic_Response
13	GetFeature
1013	GetFeature_Response
14	DescribeFeatureType
1014	DescribeFeatureType_Response
15	GetCoverage
1015	GetCoverage_Response
16	DescribeCoverage
1016	DescribeCoverage_Response
17	GetRecords
1017	GetRecords_Response
18	GetRecordById
1018	GetRecordById_Response
19	DescribeRecordType
1019	DescribeRecordType_Response
20	GetRepositoryItem
1020	GetRepositoryItem_Response
\.


--
-- Data for Name: sec_roles; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY sec_roles (id) FROM stdin;
3
9
\.


--
-- Data for Name: sec_securable_objects; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY sec_securable_objects (id, name, title) FROM stdin;
1	SEC_ADMIN	Security Admin User
2	SEC_ADMIN	Security Admin Group
3	SEC_ADMIN	Security Admin Role
6	unqualified	unqualified
8	{http://www.deegree.org/app}:unqualified	{http://www.deegree.org/app}:unqualified
9	test	test
10	test	test
14	[http://localhost:8080/wmsqualified/services]:qualified	[http://localhost:8080/wmsqualified/services]:qualified
15	[http://localhost:8080/wfsqualified/services]:{http://www.deegree.org/app}:qualified	[http://localhost:8080/wfsqualified/services]:{http://www.deegree.org/app}:qualified
4	test	test, test
\.


--
-- Data for Name: sec_secured_object_types; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY sec_secured_object_types (id, name) FROM stdin;
1	Layer
2	Featuretype
\.


--
-- Data for Name: sec_secured_objects; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY sec_secured_objects (id, fk_secured_object_types) FROM stdin;
6	1
8	2
14	1
15	2
\.


--
--

