4 INSERT INTO cred (id,ns,type,cred,expires)
\r
5 VALUES ('dgl@openecomp.org','org.openecomp',1,0xab3831f27b39d7a039f9a92aa2bbfe51,'2020-12-31');
\r
7 INSERT INTO cred (id,ns,type,cred,expires)
\r
8 VALUES ('ryan@appc.onap.org','org.onap.appc',1,0x9fb680a2292b51d5dc40335cabfa1a9a,'2020-12-31');
\r
10 INSERT INTO cred (id,ns,type,cred,expires)
\r
11 VALUES ('sai@onap.org','org.onap.appc',1,0x9fb680a2292b51d5dc40335cabfa1a9a,'2020-12-31');
\r
13 INSERT INTO cred (id,ns,type,cred,expires)
\r
14 VALUES ('shi@portal.onap.org','org.onap.portal',1,0xab3831f27b39d7a039f9a92aa2bbfe51,'2020-12-31');
\r
16 INSERT INTO cred (id,ns,type,cred,expires)
\r
17 VALUES ('admin@portal.onap.org','org.onap.portal',1,0x37c77980eee6a7d47050d199f7191ba9,'2020-12-31');
\r
19 INSERT INTO cred (id,ns,type,cred,expires)
\r
20 VALUES ('m99751@dmaapBC.openecomp.org','org.openecomp.dmaapBC',1,0xab3831f27b39d7a039f9a92aa2bbfe51,'2020-12-31');
\r
22 INSERT INTO cred (id,ns,type,cred,expires)
\r
23 VALUES ('m99501@dmaapBC.openecomp.org','org.openecomp.dmaapBC',1,0xab3831f27b39d7a039f9a92aa2bbfe51,'2020-12-31');
\r
26 // Create 'com' root NS
\r
27 INSERT INTO ns (name,scope,description,parent,type)
\r
28 VALUES('com',1,'Root Namespace',null,1);
\r
30 INSERT INTO role(ns, name, perms, description)
\r
31 VALUES('com','admin',{'com.access|*|*'},'Com Admins');
\r
33 INSERT INTO role(ns, name, perms, description)
\r
34 VALUES('com','owner',{'com.access|*|read'},'Com Owners');
\r
36 INSERT INTO perm(ns, type, instance, action, roles, description)
\r
37 VALUES ('com','access','*','read',{'com.owner'},'Com Read Access');
\r
39 INSERT INTO perm(ns, type, instance, action, roles, description)
\r
40 VALUES ('com','access','*','*',{'com.admin'},'Com Write Access');
\r
42 INSERT INTO user_role(user,role,expires,ns,rname)
\r
43 VALUES ('dgl@openecomp.org','com.owner','2020-12-31','com','owner');
\r
45 INSERT INTO user_role(user,role,expires,ns,rname)
\r
46 VALUES ('dgl@openecomp.org','com.admin','2020-12-31','com','admin');
\r
48 // Create org root NS
\r
49 INSERT INTO ns (name,scope,description,parent,type)
\r
50 VALUES('org',1,'Root Namespace Org',null,1);
\r
52 INSERT INTO ns (name,scope,description,parent,type)
\r
53 VALUES('org.openecomp.dcae',3,'DCAE Namespace Org','org.openecomp',3);
\r
55 INSERT INTO ns (name,scope,description,parent,type)
\r
56 VALUES('org.openecomp.dmaapBC',3,'DMaaP BC Namespace Org','org.openecomp',3);
\r
58 INSERT INTO role(ns, name, perms, description)
\r
59 VALUES('org','admin',{'org.access|*|*'},'Com Admins');
\r
61 INSERT INTO role(ns, name, perms, description)
\r
62 VALUES('org','owner',{'org.access|*|read'},'Com Owners');
\r
64 INSERT INTO perm(ns, type, instance, action, roles, description)
\r
65 VALUES ('org','access','*','read',{'org.owner'},'Com Read Access');
\r
67 INSERT INTO perm(ns, type, instance, action, roles, description)
\r
68 VALUES ('org','access','*','*',{'org.admin'},'Com Write Access');
\r
70 INSERT INTO user_role(user,role,expires,ns,rname)
\r
71 VALUES ('dgl@openecomp.org','org.owner','2020-12-31','org','owner');
\r
73 INSERT INTO user_role(user,role,expires,ns,rname)
\r
74 VALUES ('dgl@openecomp.org','org.admin','2020-12-31','org','admin');
\r
79 INSERT INTO ns (name,scope,description,parent,type)
\r
80 VALUES('com.att',2,'AT&T Namespace','com',2);
\r
82 INSERT INTO role(ns, name, perms,description)
\r
83 VALUES('com.att','admin',{'com.att.access|*|*'},'AT&T Admins');
\r
85 INSERT INTO role(ns, name, perms,description)
\r
86 VALUES('com.att','owner',{'com.att.access|*|read'},'AT&T Owners');
\r
88 INSERT INTO perm(ns, type, instance, action, roles,description)
\r
89 VALUES ('com.att','access','*','read',{'com.att.owner'},'AT&T Read Access');
\r
91 INSERT INTO perm(ns, type, instance, action, roles,description)
\r
92 VALUES ('com.att','access','*','*',{'com.att.admin'},'AT&T Write Access');
\r
94 INSERT INTO user_role(user,role,expires,ns,rname)
\r
95 VALUES ('dgl@openecomp.org','com.att.owner','2020-12-31','com.att','owner');
\r
97 INSERT INTO user_role(user,role,expires,ns,rname)
\r
98 VALUES ('dgl@openecomp.org','com.att.admin','2020-12-31','com.att','admin');
\r
100 // Create com.att.aaf
\r
102 INSERT INTO ns (name,scope,description,parent,type)
\r
103 VALUES('com.att.aaf',3,'Application Authorization Framework','com.att',3);
\r
105 INSERT INTO role(ns, name, perms, description)
\r
106 VALUES('com.att.aaf','admin',{'com.att.aaf.access|*|*'},'AAF Admins');
\r
108 INSERT INTO role(ns, name, perms, description)
\r
109 VALUES('com.att.aaf','owner',{'com.att.aaf.access|*|read'},'AAF Owners');
\r
111 INSERT INTO perm(ns, type, instance, action, roles, description)
\r
112 VALUES ('com.att.aaf','access','*','read',{'com.att.aaf.owner'},'AAF Read Access');
\r
114 INSERT INTO perm(ns, type, instance, action, roles, description)
\r
115 VALUES ('com.att.aaf','access','*','*',{'com.att.aaf.admin'},'AAF Write Access');
\r
117 INSERT INTO user_role(user,role,expires,ns,rname)
\r
118 VALUES ('dgl@openecomp.org','com.att.aaf.admin','2020-12-31','com.att.aaf','admin');
\r
119 INSERT INTO user_role(user,role,expires,ns,rname)
\r
120 VALUES ('dgl@openecomp.org','com.att.aaf.owner','2020-12-31','com.att.aaf','owner');
\r
123 // Create org.openecomp
\r
124 INSERT INTO ns (name,scope,description,parent,type)
\r
125 VALUES('org.openecomp',2,'Open EComp NS','com.att',2);
\r
127 INSERT INTO role(ns, name, perms, description)
\r
128 VALUES('org.openecomp','admin',{'org.openecomp.access|*|*'},'OpenEcomp Admins');
\r
130 INSERT INTO role(ns, name, perms, description)
\r
131 VALUES('org.openecomp','owner',{'org.openecomp.access|*|read'},'OpenEcomp Owners');
\r
133 INSERT INTO perm(ns, type, instance, action, roles, description)
\r
134 VALUES ('org.openecomp','access','*','read',{'org.openecomp.owner'},'OpenEcomp Read Access');
\r
136 INSERT INTO perm(ns, type, instance, action, roles, description)
\r
137 VALUES ('org.openecomp','access','*','*',{'org.openecomp.admin'},'OpenEcomp Write Access');
\r
139 INSERT INTO user_role(user,role,expires,ns,rname)
\r
140 VALUES ('dgl@openecomp.org','org.openecomp.admin','2020-12-31','org.openecomp','admin');
\r
146 INSERT INTO ns (name,scope,description,parent,type)
\r
147 VALUES('org.onap',2,'Onap NS','com.att',2);
\r
149 INSERT INTO role(ns, name, perms, description)
\r
150 VALUES('org.onap','admin',{'org.onap.access|*|*'},'Onap Admins');
\r
152 INSERT INTO role(ns, name, perms, description)
\r
153 VALUES('org.onap','owner',{'org.onap.access|*|read'},'onap Owners');
\r
155 INSERT INTO perm(ns, type, instance, action, roles, description)
\r
156 VALUES ('org.onap','access','*','read',{'org.onap.owner'},'Onap Read Access');
\r
158 INSERT INTO perm(ns, type, instance, action, roles, description)
\r
159 VALUES ('org.onap','access','*','*',{'org.onap.admin'},'Onap Write Access');
\r
161 INSERT INTO user_role(user,role,expires,ns,rname)
\r
162 VALUES ('dgl@openecomp.org','org.onap.admin','2020-12-31','org.onap','admin');
\r
164 INSERT INTO user_role(user,role,expires,ns,rname)
\r
165 VALUES ('sai@onap.org','org.onap.admin','2020-12-31','org.onap','admin');
\r
169 // Create org.onap.appc
\r
170 INSERT INTO ns (name,scope,description,parent,type)
\r
171 VALUES('org.onap.appc',2,'Onap NS','com.att',2);
\r
173 INSERT INTO role(ns, name, perms, description)
\r
174 VALUES('org.onap.appc','admin',{'org.onap.appc.access|*|*'},'OnapAPPC Admins');
\r
176 INSERT INTO role(ns, name, perms, description)
\r
177 VALUES('org.onap.appc','owner',{'org.onap.appc.access|*|read'},'onap APPC Owners');
\r
179 INSERT INTO perm(ns, type, instance, action, roles, description)
\r
180 VALUES ('org.onap.appc','access','*','read',{'org.onap.appc.owner'},'Onap Read Access');
\r
182 INSERT INTO perm(ns, type, instance, action, roles, description)
\r
183 VALUES ('org.onap.appc','access','*','*',{'org.onap.appc.admin'},'Onap Write Access');
\r
185 INSERT INTO user_role(user,role,expires,ns,rname)
\r
186 VALUES ('dgl@openecomp.org','org.onap.appc.admin','2020-12-31','org.onap.appc','admin');
\r
188 INSERT INTO user_role(user,role,expires,ns,rname)
\r
189 VALUES ('sai@onap.org','org.onap.appc.admin','2020-12-31','org.onap.appc','admin');
\r
191 INSERT INTO user_role(user,role,expires,ns,rname)
\r
192 VALUES ('ryan@appc.onap.org','org.onap.appc.admin','2020-12-31','org.onap.appc','admin');
\r
196 // Create org.onap.portal
\r
197 INSERT INTO ns (name,scope,description,parent,type)
\r
198 VALUES('org.onap.portal',2,'Onap NS','com.att',2);
\r
200 INSERT INTO role(ns, name, perms, description)
\r
201 VALUES('org.onap.portal','admin',{'org.onap.portal.access|*|*'},'Onap Portal Admins');
\r
203 INSERT INTO role(ns, name, perms, description)
\r
204 VALUES('org.onap.portal','owner',{'org.onap.portal.access|*|read'},'onap Portal Owners');
\r
206 INSERT INTO perm(ns, type, instance, action, roles, description)
\r
207 VALUES ('org.onap.portal','access','*','read',{'org.onap.portal.owner'},'Onap Portal Read Access');
\r
209 INSERT INTO perm(ns, type, instance, action, roles, description)
\r
210 VALUES ('org.onap.portal','access','*','*',{'org.onap.portal.admin'},'Onap Portal Write Access');
\r
212 INSERT INTO role(ns, name, perms, description)
\r
213 VALUES('org.onap.portal','System_Administrator',{'org.onap.portal.access|*|*'},
\r
214 '{\"id\":\"1\",\"name\":\"System Administrator\",\"active\":\"true\",\"priority\":\"1\",\"appId\":\"NULL\",\"appRoleId\":\"NULL\"},'System Administrator');
\r
216 INSERT INTO role(ns, name, perms, description)
\r
217 VALUES('org.onap.portal','Standard_User',{'org.onap.portal.access|*|*'},
\r
218 '{\"id\":\"16\",\"name\":\"Standard User\",\"active\":\"true\",\"priority\":\"5\",\"appId\":\"NULL\",\"appRoleId\":\"NULL\"},'Standard User');
\r
220 INSERT INTO role(ns, name, perms, description)
\r
221 VALUES('org.onap.portal','Restricted_App_Role',{'org.onap.portal.access|*|*'},
\r
222 '{\"id\":\"900\",\"name\":\"Restricted App Role\",\"active\":\"true\",\"priority\":\"1\",\"appId\":\"NULL\",\"appRoleId\":\"NULL\"},'Restricted App Role');
\r
224 INSERT INTO role(ns, name, perms, description)
\r
225 VALUES('org.onap.portal','Portal_Notification_Admin',{'org.onap.portal.access|*|*'},
\r
226 '{\"id\":\"950\",\"name\":\"Portal Notification Admin\",\"active\":\"true\",\"priority\":\"1\",\"appId\":\"NULL\",\"appRoleId\":\"NULL\"},'Portal Notification Admin');
\r
228 INSERT INTO role(ns, name, perms, description)
\r
229 VALUES('org.onap.portal','Account_Administrator',{'org.onap.portal.access|*|*'},
\r
230 '{\"id\":\"999\",\"name\":\"Account Administrator\",\"active\":\"true\",\"priority\":\"1\",\"appId\":\"NULL\",\"appRoleId\":\"NULL\"},'Account Administrator');
\r
233 INSERT INTO user_role(user,role,expires,ns,rname)
\r
234 VALUES ('dgl@openecomp.org','org.onap.portal.admin','2020-12-31','org.onap.portal','admin');
\r
236 INSERT INTO user_role(user,role,expires,ns,rname)
\r
237 VALUES ('admin@portal.onap.org','org.onap.portal.admin','2020-12-31','org.onap.portal','admin');
\r
239 INSERT INTO user_role(user,role,expires,ns,rname)
\r
240 VALUES ('shi@portal.onap.org','org.onap.portal.admin','2020-12-31','org.onap.portal','admin');
\r
243 INSERT INTO user_role(user,role,expires,ns,rname)
\r
244 VALUES ('admin@portal.onap.org','org.onap.portal.admin','2020-12-31','org.onap.portal','System_Administrator');
\r
246 INSERT INTO user_role(user,role,expires,ns,rname)
\r
247 VALUES ('admin@portal.onap.org','org.onap.portal.admin','2020-12-31','org.onap.portal','Standard_User');
\r
249 INSERT INTO user_role(user,role,expires,ns,rname)
\r
250 VALUES ('admin@portal.onap.org','org.onap.portal.admin','2020-12-31','org.onap.portal','Restricted_App_Role');
\r
252 INSERT INTO user_role(user,role,expires,ns,rname)
\r
253 VALUES ('admin@portal.onap.org','org.onap.portal.admin','2020-12-31','org.onap.portal','Portal_Notification_Admin');
\r
255 INSERT INTO user_role(user,role,expires,ns,rname)
\r
256 VALUES ('admin@portal.onap.org','org.onap.portal.admin','2020-12-31','org.onap.portal','Account_Administrator');
\r
263 // Create org.openecomp.dmaapBC
\r
265 INSERT INTO ns (name,scope,description,parent,type)
\r
266 VALUES('org.openecomp.dmaapBC',3,'Application Authorization Framework','org.openecomp',3);
\r
268 //INSERT INTO role(ns, name, perms, description)
\r
269 // VALUES('org.openecomp.dmaapBC','admin',{'org.openecomp.dmaapBC.access|*|*'},'AAF Admins');
\r
271 INSERT INTO role(ns, name, perms, description)
\r
272 VALUES('org.openecomp.dmaapBC','admin',{'org.openecomp.dmaapBC.access|*|*','org.openecomp.dmaapBC.topicFactory|:org.openecomp.dmaapBC.topic:org.openecomp.dmaapBC|create','org.openecomp.dmaapBC.mr.topic|:topic.org.openecomp.dmaapBC.newtopic|sub','org.openecomp.dmaapBC.mr.topic|:topic.org.openecomp.dmaapBC.newtopic|pub'},'AAF Admins');
\r
274 //INSERT INTO role(ns, name, perms, description)
\r
275 //VALUES('org.openecomp.dmaapBC','admin',{'org.openecomp.dmaapBC.access|*|*','org.openecomp.dmaapBC.mr.topic|:topic.org.openecomp.dmaapBC.newtopic|sub'},'AAF Admins');
\r
277 //INSERT INTO role(ns, name, perms, description)
\r
278 //VALUES('org.openecomp.dmaapBC','admin',{'org.openecomp.dmaapBC.access|*|*','org.openecomp.dmaapBC.mr.topic|:topic.org.openecomp.dmaapBC.newtopic|pub'},'AAF Admins');
\r
282 INSERT INTO role(ns, name, perms, description)
\r
283 VALUES('org.openecomp.dmaapBC','owner',{'org.openecomp.dmaapBC.access|*|read'},'AAF Owners');
\r
285 INSERT INTO perm(ns, type, instance, action, roles, description)
\r
286 VALUES ('org.openecomp.dmaapBC','access','*','read',{'org.openecomp.dmaapBC.owner'},'AAF Read Access');
\r
288 INSERT INTO perm(ns, type, instance, action, roles, description)
\r
289 VALUES ('org.openecomp.dmaapBC','access','*','*',{'org.openecomp.dmaapBC.admin'},'AAF Write Access');
\r
291 INSERT INTO user_role(user,role,expires,ns,rname)
\r
292 VALUES ('dgl@openecomp.org','org.openecomp.dmaapBC.admin','2020-12-31','org.openecomp.dmaapBC','admin');
\r
293 INSERT INTO user_role(user,role,expires,ns,rname)
\r
294 VALUES ('dgl@openecomp.org','org.openecomp.dmaapBC.owner','2020-12-31','org.openecomp.dmaapBC','owner');
\r
295 INSERT INTO user_role(user,role,expires,ns,rname)
\r
296 VALUES ('m99751@dmaapBC.openecomp.org','org.openecomp.dmaapBC.admin','2020-12-31','org.openecomp.dmaapBC','admin');
\r
297 INSERT INTO user_role(user,role,expires,ns,rname)
\r
298 VALUES ('m99751@dmaapBC.openecomp.org','org.openecomp.dmaapBC.owner','2020-12-31','org.openecomp.dmaapBC','owner');
\r
299 INSERT INTO user_role(user,role,expires,ns,rname)
\r
300 VALUES ('m99501@dmaapBC.openecomp.org','org.openecomp.dmaapBC.admin','2020-12-31','org.openecomp.dmaapBC','admin');
\r
301 INSERT INTO user_role(user,role,expires,ns,rname)
\r
302 VALUES ('m99501@dmaapBC.openecomp.org','org.openecomp.dmaapBC.owner','2020-12-31','org.openecomp.dmaapBC','owner');
\r