Warning: mysqli_num_fields() expects parameter 1 to be mysqli_result, boolean given in /www/wwwroot/dev.zhalaotie.com/wp-includes/wp-db.php on line 3215

Warning: mysqli_num_fields() expects parameter 1 to be mysqli_result, boolean given in /www/wwwroot/dev.zhalaotie.com/wp-includes/wp-db.php on line 3215
分配权限 SQL grant permission(Rhythm Framework) – 扎老铁
Warning: mysqli_num_fields() expects parameter 1 to be mysqli_result, boolean given in /www/wwwroot/dev.zhalaotie.com/wp-includes/wp-db.php on line 3215

Warning: mysqli_num_fields() expects parameter 1 to be mysqli_result, boolean given in /www/wwwroot/dev.zhalaotie.com/wp-includes/wp-db.php on line 3215
Warning: mysqli_num_fields() expects parameter 1 to be mysqli_result, boolean given in /www/wwwroot/dev.zhalaotie.com/wp-includes/wp-db.php on line 3215
class="post-52972 post type-post status-publish format-standard hentry">

分配权限 SQL grant permission(Rhythm Framework)

如果没有权限,或要修复权限,可以情况权限表

然后,执行如下 SQL,为 id 为 3 的用户(rootuser)分配一个“分配权限页面”的页面权限和保存权限。

 

 

执行如果报错,先清空

bx_rhythm_security_accesscontrol_permission

bx_rhythm_security_accesscontrol_permissionsetreference

这两张表。

 

use  bitlab_iot;


INSERT INTO `bx_rhythm_security_accesscontrol_permission` (`Operation`, `Rights`, `ResultType`, `IdentityId`, `Id`, `AuthorizationType`) VALUES ('Rhythm.Update`1[[Rhythm.Security.AccessControl.FeatureAuthorization, Rhythm.Security, Version=1.0.6220.37963, Culture=neutral, PublicKeyToken=null]],Rhythm.Core', '{\"$type\":\"System.Collections.Generic.Dictionary`2[[System.Type, mscorlib],[System.Object, mscorlib]], mscorlib\",\"Rhythm.Security.AccessControl.FeatureAuthorization, Rhythm.Security, Culture=neutral, PublicKeyToken=null\":{\"$type\":\"Rhythm.Security.AccessControl.FeatureAuthorization, Rhythm.Security\",\"Value\":true}}', '', 'User:4', '2225', 'Rhythm.Security.AccessControl.FeatureAuthorization,Rhythm.Security');
INSERT INTO `bx_rhythm_security_accesscontrol_permission` (`Operation`, `Rights`, `ResultType`, `IdentityId`, `Id`, `AuthorizationType`) VALUES ('Rhythm.Read`1[[Rhythm.Security.AccessControl.FeatureAuthorization, Rhythm.Security, Version=1.0.6220.37963, Culture=neutral, PublicKeyToken=null]],Rhythm.Core', '{\"$type\":\"System.Collections.Generic.Dictionary`2[[System.Type, mscorlib],[System.Object, mscorlib]], mscorlib\",\"Rhythm.Security.AccessControl.FeatureAuthorization, Rhythm.Security, Culture=neutral, PublicKeyToken=null\":{\"$type\":\"Rhythm.Security.AccessControl.FeatureAuthorization, Rhythm.Security\",\"Value\":true}}', '', 'User:4', '2226', 'Rhythm.Security.AccessControl.FeatureAuthorization,Rhythm.Security');

--
-- 用户角色数据,可以不添加此数据
--

LOCK TABLES `bx_rhythm_security_accesscontrol_permissionsetreference` WRITE;
/*!40000 ALTER TABLE `bx_rhythm_security_accesscontrol_permissionsetreference` DISABLE KEYS */;
INSERT INTO `bx_rhythm_security_accesscontrol_permissionsetreference` VALUES ('Ref-User:4','[\"Role:3\"]'),('Ref-User:5','[\"Role:3\",\"Role:7\"]'),('Ref-User:6','[\"8\"]'),('Ref-User:roim','[\"Role:3\"]');
/*!40000 ALTER TABLE `bx_rhythm_security_accesscontrol_permissionsetreference` ENABLE KEYS */;
UNLOCK TABLES;

 

 

 

然后,重启 Web 服务,以 rootuser 登录,用浏览器访问功能权限管理地址:

老版:
http://localhost:40001/Management/AuthorizationAccessControl/edit?identityId=User:3

新版:

http://localhost:40001/Management/FeatureAuthorization/edit?identityId=User:3

发表评论

电子邮件地址不会被公开。