diff options
| author | TDB Release <tdb-release@build.bot> | 2021-07-15 07:35:10 +0000 |
|---|---|---|
| committer | TDB Release <tdb-release@build.bot> | 2021-07-15 07:35:10 +0000 |
| commit | a47926ceab7091dd0c06b6bb16a0d1f64bd30a63 (patch) | |
| tree | 11e3622fbe1e4f323d81c868d114a97905e43f7a /sql/updates/auth | |
| parent | 24bd519f5ccbf444434aec50e956d8a904dac4c8 (diff) | |
TDB 335.21071 - 2021/07/15TDB335.21071
Diffstat (limited to 'sql/updates/auth')
| -rw-r--r-- | sql/updates/auth/3.3.5/2021_06_20_00_auth.sql | 13 | ||||
| -rw-r--r-- | sql/updates/auth/3.3.5/2021_07_15_00_auth.sql (renamed from sql/updates/auth/3.3.5/2021_06_15_00_auth.sql) | 2 |
2 files changed, 1 insertions, 14 deletions
diff --git a/sql/updates/auth/3.3.5/2021_06_20_00_auth.sql b/sql/updates/auth/3.3.5/2021_06_20_00_auth.sql deleted file mode 100644 index 4b8209a2123..00000000000 --- a/sql/updates/auth/3.3.5/2021_06_20_00_auth.sql +++ /dev/null @@ -1,13 +0,0 @@ --- -DROP VIEW IF EXISTS `vw_rbac`; - -CREATE SQL SECURITY INVOKER VIEW `vw_rbac` AS -( - SELECT `t1`.`linkedId` AS `Permission ID`, - `t1`.`id` AS `Permission Group`, - IFNULL(`t2`.`secId`, 'linked') AS `Security Level`, - `t3`.`name` AS `Permission` - FROM `rbac_linked_permissions` `t1` - LEFT JOIN `rbac_default_permissions` `t2` ON `t1`.`id` = `t2`.`permissionId` - LEFT JOIN `rbac_permissions` `t3` ON `t1`.`linkedId` = `t3`.`id` -); diff --git a/sql/updates/auth/3.3.5/2021_06_15_00_auth.sql b/sql/updates/auth/3.3.5/2021_07_15_00_auth.sql index 3986a5535e0..7b8b20b47a2 100644 --- a/sql/updates/auth/3.3.5/2021_06_15_00_auth.sql +++ b/sql/updates/auth/3.3.5/2021_07_15_00_auth.sql @@ -1,2 +1,2 @@ --- TDB 335.21061 auth +-- TDB 335.21071 auth UPDATE `updates` SET `state`='ARCHIVED'; |