SELECT UserOrgPerm.FRuleExpr FROM T_PM_UserOrgPerm USERORGPERM WHERE ( ( ( UserOrgPerm.FOwner = '256c221a-0106-1000-e000-10d7c0a813f413B7DE7F' AND UserOrgPerm.FOrgID = '11111111-1111-1111-1111-111111111111CCE7AED4' ) AND UserOrgPerm.FPermItemID = '5118976f-00fd-1000-e000-0010c0a813dePERMITEM' ) AND UserOrgPerm.FPermType = 10 ) UNION SELECT RolePerm.FRuleExpr FROM T_PM_RolePerm ROLEPERM INNER JOIN T_PM_UserRoleOrg USERROLEORG ON UserRoleOrg.FRoleID = RolePerm.FRoleID WHERE ( ( ( UserRoleOrg.FUserID = '256c221a-0106-1000-e000-10d7c0a813f413B7DE7F' AND( 1 = 1 OR UserRoleOrg.FOrgID = '11111111-1111-1111-1111-111111111111CCE7AED4' ) ) AND RolePerm.FPermItemID = '5118976f-00fd-1000-e000-0010c0a813dePERMITEM' ) AND RolePerm.FPermType = 10 )blob字段不允许distinct、insert、update等操作。他是特殊的对象,其实数据库里纪录的只是一个类似指针的对象,就象一个视图的概念
版权声明:本文为hu00848原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。