• Home
• io.gravitee.am.repository
• gravitee-am-repository-jdbc
• 4.5.0-alpha.3
• source code
• 4.3.0-license-notification-permission.yml

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

liquibase.changelogs.v4_3_0.4.3.0-license-notification-permission.yml Maven / Gradle / Ivy

databaseChangeLog:
  - changeSet:
      id: 4.3.0-license-notification-permission
      author: GraviteeSource Team
      changes:
        # Add licence notification permission
        ##############
        - sql:
            dbms: postgresql
            sql: "UPDATE roles SET permission_acls = jsonb_set(cast(permission_acls as jsonb), '{LICENSE_NOTIFICATION}', '[\"READ\"]', true)  WHERE name in ('ORGANIZATION_PRIMARY_OWNER', 'ORGANIZATION_OWNER');"

        - sql:
            dbms: mysql, mariadb
            sql: "UPDATE roles SET permission_acls = JSON_SET(permission_acls, '$.LICENSE_NOTIFICATION', JSON_ARRAY('READ')) WHERE name in ('ORGANIZATION_PRIMARY_OWNER', 'ORGANIZATION_OWNER');"

        - sql:
            dbms: mssql
            sql: "UPDATE roles SET permission_acls = JSON_MODIFY(permission_acls, '$.LICENSE_NOTIFICATION', JSON_QUERY('[\"READ\"]', '$')) WHERE name in ('ORGANIZATION_PRIMARY_OWNER', 'ORGANIZATION_OWNER');"