[Migration-Shared DB] Support application roles for Identity Server and support RBAC for apps

wso2 / product-is

Welcome to the WSO2 Identity Server source code! For info on working with the WSO2 Identity Server repository and contributing code, click the link below.

http://wso2.github.io/

Apache License 2.0

746 stars 724 forks source link

[Migration-Shared DB] Support application roles for Identity Server and support RBAC for apps #16864

Open shashimalcse opened 1 year ago

shashimalcse commented 1 year ago

Describe the issue:

Due to the requirement in https://github.com/wso2/product-is/issues/16363,

added new tables
- UM_HYBRID_ROLE_AUDIENCE
- UM_IDP_GROUP_ROLE
- UM_SHARED_ROLE
added column named UM_AUDIENCE_REF_ID , UM_UUID column to UM_HYBRID_ROLE table
changed unique constrain of table UM_HYBRID_ROLE to UNIQUE(UM_ROLE_NAME,UM_TENANT_ID,UM_AUDIENCE_REF_ID)

Schema PR : https://github.com/wso2/carbon-kernel/pull/3673

shashimalcse commented 10 months ago

added with : https://github.com/wso2-enterprise/identity-migration-resources/pull/315