4 INSERT INTO cred (id,ns,type,cred,expires)
5 VALUES ('dgl@openecomp.org','org.openecomp',1,0xab3831f27b39d7a039f9a92aa2bbfe51,'2020-12-31');
7 INSERT INTO cred (id,ns,type,cred,expires)
8 VALUES ('ryan@appc.onap.org','org.onap.appc',1,0x9fb680a2292b51d5dc40335cabfa1a9a,'2020-12-31');
10 INSERT INTO cred (id,ns,type,cred,expires)
11 VALUES ('sai@onap.org','org.onap.appc',1,0x9fb680a2292b51d5dc40335cabfa1a9a,'2020-12-31');
13 INSERT INTO cred (id,ns,type,cred,expires)
14 VALUES ('shi@portal.onap.org','org.onap.portal',1,0xab3831f27b39d7a039f9a92aa2bbfe51,'2020-12-31');
16 INSERT INTO cred (id,ns,type,cred,expires)
17 VALUES ('admin@portal.onap.org','org.onap.portal',1,0x37c77980eee6a7d47050d199f7191ba9,'2020-12-31');
19 INSERT INTO cred (id,ns,type,cred,expires)
20 VALUES ('clamp@clamp.onap.org','org.onap.clamp',1,0xe18977785f423b7c3e5d1f283fce4e2e,'2020-12-31');
22 INSERT INTO cred (id,ns,type,cred,expires)
23 VALUES ('m99751@dmaapBC.openecomp.org','org.openecomp.dmaapBC',1,0xab3831f27b39d7a039f9a92aa2bbfe51,'2020-12-31');
25 INSERT INTO cred (id,ns,type,cred,expires)
26 VALUES ('m99501@dmaapBC.openecomp.org','org.openecomp.dmaapBC',1,0xab3831f27b39d7a039f9a92aa2bbfe51,'2020-12-31');
29 // Create 'com' root NS
30 INSERT INTO ns (name,scope,description,parent,type)
31 VALUES('com',1,'Root Namespace',null,1);
33 INSERT INTO role(ns, name, perms, description)
34 VALUES('com','admin',{'com.access|*|*'},'Com Admins');
36 INSERT INTO role(ns, name, perms, description)
37 VALUES('com','owner',{'com.access|*|read'},'Com Owners');
39 INSERT INTO perm(ns, type, instance, action, roles, description)
40 VALUES ('com','access','*','read',{'com.owner'},'Com Read Access');
42 INSERT INTO perm(ns, type, instance, action, roles, description)
43 VALUES ('com','access','*','*',{'com.admin'},'Com Write Access');
45 INSERT INTO user_role(user,role,expires,ns,rname)
46 VALUES ('dgl@openecomp.org','com.owner','2020-12-31','com','owner');
48 INSERT INTO user_role(user,role,expires,ns,rname)
49 VALUES ('dgl@openecomp.org','com.admin','2020-12-31','com','admin');
52 INSERT INTO ns (name,scope,description,parent,type)
53 VALUES('org',1,'Root Namespace Org',null,1);
55 INSERT INTO ns (name,scope,description,parent,type)
56 VALUES('org.openecomp.dcae',3,'DCAE Namespace Org','org.openecomp',3);
58 INSERT INTO ns (name,scope,description,parent,type)
59 VALUES('org.openecomp.dmaapBC',3,'DMaaP BC Namespace Org','org.openecomp',3);
61 INSERT INTO role(ns, name, perms, description)
62 VALUES('org','admin',{'org.access|*|*'},'Com Admins');
64 INSERT INTO role(ns, name, perms, description)
65 VALUES('org','owner',{'org.access|*|read'},'Com Owners');
67 INSERT INTO perm(ns, type, instance, action, roles, description)
68 VALUES ('org','access','*','read',{'org.owner'},'Com Read Access');
70 INSERT INTO perm(ns, type, instance, action, roles, description)
71 VALUES ('org','access','*','*',{'org.admin'},'Com Write Access');
73 INSERT INTO user_role(user,role,expires,ns,rname)
74 VALUES ('dgl@openecomp.org','org.owner','2020-12-31','org','owner');
76 INSERT INTO user_role(user,role,expires,ns,rname)
77 VALUES ('dgl@openecomp.org','org.admin','2020-12-31','org','admin');
82 INSERT INTO ns (name,scope,description,parent,type)
83 VALUES('com.att',2,'AT&T Namespace','com',2);
85 INSERT INTO role(ns, name, perms,description)
86 VALUES('com.att','admin',{'com.att.access|*|*'},'AT&T Admins');
88 INSERT INTO role(ns, name, perms,description)
89 VALUES('com.att','owner',{'com.att.access|*|read'},'AT&T Owners');
91 INSERT INTO perm(ns, type, instance, action, roles,description)
92 VALUES ('com.att','access','*','read',{'com.att.owner'},'AT&T Read Access');
94 INSERT INTO perm(ns, type, instance, action, roles,description)
95 VALUES ('com.att','access','*','*',{'com.att.admin'},'AT&T Write Access');
97 INSERT INTO user_role(user,role,expires,ns,rname)
98 VALUES ('dgl@openecomp.org','com.att.owner','2020-12-31','com.att','owner');
100 INSERT INTO user_role(user,role,expires,ns,rname)
101 VALUES ('dgl@openecomp.org','com.att.admin','2020-12-31','com.att','admin');
103 // Create com.att.aaf
105 INSERT INTO ns (name,scope,description,parent,type)
106 VALUES('com.att.aaf',3,'Application Authorization Framework','com.att',3);
108 INSERT INTO role(ns, name, perms, description)
109 VALUES('com.att.aaf','admin',{'com.att.aaf.access|*|*'},'AAF Admins');
111 INSERT INTO role(ns, name, perms, description)
112 VALUES('com.att.aaf','owner',{'com.att.aaf.access|*|read'},'AAF Owners');
114 INSERT INTO perm(ns, type, instance, action, roles, description)
115 VALUES ('com.att.aaf','access','*','read',{'com.att.aaf.owner'},'AAF Read Access');
117 INSERT INTO perm(ns, type, instance, action, roles, description)
118 VALUES ('com.att.aaf','access','*','*',{'com.att.aaf.admin'},'AAF Write Access');
120 INSERT INTO user_role(user,role,expires,ns,rname)
121 VALUES ('dgl@openecomp.org','com.att.aaf.admin','2020-12-31','com.att.aaf','admin');
122 INSERT INTO user_role(user,role,expires,ns,rname)
123 VALUES ('dgl@openecomp.org','com.att.aaf.owner','2020-12-31','com.att.aaf','owner');
126 // Create org.openecomp
127 INSERT INTO ns (name,scope,description,parent,type)
128 VALUES('org.openecomp',2,'Open EComp NS','com.att',2);
130 INSERT INTO role(ns, name, perms, description)
131 VALUES('org.openecomp','admin',{'org.openecomp.access|*|*'},'OpenEcomp Admins');
133 INSERT INTO role(ns, name, perms, description)
134 VALUES('org.openecomp','owner',{'org.openecomp.access|*|read'},'OpenEcomp Owners');
136 INSERT INTO perm(ns, type, instance, action, roles, description)
137 VALUES ('org.openecomp','access','*','read',{'org.openecomp.owner'},'OpenEcomp Read Access');
139 INSERT INTO perm(ns, type, instance, action, roles, description)
140 VALUES ('org.openecomp','access','*','*',{'org.openecomp.admin'},'OpenEcomp Write Access');
142 INSERT INTO user_role(user,role,expires,ns,rname)
143 VALUES ('dgl@openecomp.org','org.openecomp.admin','2020-12-31','org.openecomp','admin');
149 INSERT INTO ns (name,scope,description,parent,type)
150 VALUES('org.onap',2,'Open ONAP NS','com.att',2);
152 INSERT INTO role(ns, name, perms, description)
153 VALUES('org.onap','admin',{'org.onap.access|*|*'},'onap Admins');
155 INSERT INTO role(ns, name, perms, description)
156 VALUES('org.onap','owner',{'org.onap.access|*|read'},'onap Owners');
158 INSERT INTO perm(ns, type, instance, action, roles, description)
159 VALUES ('org.onap','access','*','read',{'org.onap.owner'},'onap Read Access');
161 INSERT INTO perm(ns, type, instance, action, roles, description)
162 VALUES ('org.onap','access','*','*',{'org.onap.admin'},'onap Write Access');
164 INSERT INTO user_role(user,role,expires,ns,rname)
165 VALUES ('dgl@openecomp.org','org.onap.admin','2020-12-31','org.onap','admin');
167 INSERT INTO user_role(user,role,expires,ns,rname)
168 VALUES ('dgl@openecomp.org','org.onap.owner','2020-12-31','org.onap','admin');
171 // Create org.openecomp.dmaapBC
173 INSERT INTO ns (name,scope,description,parent,type)
174 VALUES('org.openecomp.dmaapBC',3,'Application Authorization Framework','org.openecomp',3);
177 INSERT INTO role(ns, name, perms, description)
178 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');
181 INSERT INTO role(ns, name, perms, description)
182 VALUES('org.openecomp.dmaapBC','owner',{'org.openecomp.dmaapBC.access|*|read'},'AAF Owners');
184 INSERT INTO perm(ns, type, instance, action, roles, description)
185 VALUES ('org.openecomp.dmaapBC','access','*','read',{'org.openecomp.dmaapBC.owner'},'AAF Read Access');
187 INSERT INTO perm(ns, type, instance, action, roles, description)
188 VALUES ('org.openecomp.dmaapBC','access','*','*',{'org.openecomp.dmaapBC.admin'},'AAF Write Access');
190 INSERT INTO user_role(user,role,expires,ns,rname)
191 VALUES ('dgl@openecomp.org','org.openecomp.dmaapBC.admin','2020-12-31','org.openecomp.dmaapBC','admin');
193 INSERT INTO user_role(user,role,expires,ns,rname)
194 VALUES ('dgl@openecomp.org','org.openecomp.dmaapBC.owner','2020-12-31','org.openecomp.dmaapBC','owner');
196 INSERT INTO user_role(user,role,expires,ns,rname)
197 VALUES ('m99751@dmaapBC.openecomp.org','org.openecomp.dmaapBC.admin','2020-12-31','org.openecomp.dmaapBC','admin');
199 INSERT INTO user_role(user,role,expires,ns,rname)
200 VALUES ('m99751@dmaapBC.openecomp.org','org.openecomp.dmaapBC.owner','2020-12-31','org.openecomp.dmaapBC','owner');
202 INSERT INTO user_role(user,role,expires,ns,rname)
203 VALUES ('m99501@dmaapBC.openecomp.org','org.openecomp.dmaapBC.admin','2020-12-31','org.openecomp.dmaapBC','admin');
205 INSERT INTO user_role(user,role,expires,ns,rname)
206 VALUES ('m99501@dmaapBC.openecomp.org','org.openecomp.dmaapBC.owner','2020-12-31','org.openecomp.dmaapBC','owner');