自定义。
已解决。
select * from (select Permission_code from iam_role_permission where Role_code =‘role/project/default/project-member’ and Permission_code like ‘knowledgebase-service%’)a
left join
(select Permission_code from iam_role_permission where Role_code =‘role/project/custom/project-cfg-member’ and Permission_code like ‘knowledgebase-service%’)b
on a.Permission_code=b.Permission_code
where b.Permission_code is null
INSERT INTO base_service
.iam_role_permission
(role_CODE
,PERMISSION_CODE
,OBJECT_VERSION_NUMBER
,CREATED_BY
,CREATION_DATE
,LAST_UPDATED_BY
,LAST_UPDATE_DATE
)VALUES(‘role/project/custom/project-dev-member’,‘knowledgebase-service.document-template.deleteAttach’ ,1,38,‘2020-04-20 13:0:0’,38,‘2020-04-21 13:0:0’);
INSERT INTO base_service
.iam_role_permission
(role_CODE
,PERMISSION_CODE
,OBJECT_VERSION_NUMBER
,CREATED_BY
,CREATION_DATE
,LAST_UPDATED_BY
,LAST_UPDATE_DATE
)VALUES(‘role/project/custom/project-dev-member’,‘knowledgebase-service.page-project.createPageByTemplate’ ,1,38,‘2020-04-20 13:0:0’,38,‘2020-04-21 13:0:0’);
INSERT INTO base_service
.iam_role_permission
(role_CODE
,PERMISSION_CODE
,OBJECT_VERSION_NUMBER
,CREATED_BY
,CREATION_DATE
,LAST_UPDATED_BY
,LAST_UPDATE_DATE
)VALUES(‘role/project/custom/project-dev-member’,‘knowledgebase-service.work-space-project.belongToBaseDelete’ ,1,38,‘2020-04-20 13:0:0’,38,‘2020-04-21 13:0:0’);
INSERT INTO base_service
.iam_role_permission
(role_CODE
,PERMISSION_CODE
,OBJECT_VERSION_NUMBER
,CREATED_BY
,CREATION_DATE
,LAST_UPDATED_BY
,LAST_UPDATE_DATE
)VALUES(‘role/project/custom/project-dev-member’,‘knowledgebase-service.work-space-project.clonePage’ ,1,38,‘2020-04-20 13:0:0’,38,‘2020-04-21 13:0:0’);
INSERT INTO base_service
.iam_role_permission
(role_CODE
,PERMISSION_CODE
,OBJECT_VERSION_NUMBER
,CREATED_BY
,CREATION_DATE
,LAST_UPDATED_BY
,LAST_UPDATE_DATE
)VALUES(‘role/project/custom/project-dev-member’,‘knowledgebase-service.work-space-project.listAllSpace’ ,1,38,‘2020-04-20 13:0:0’,38,‘2020-04-21 13:0:0’);