|
我按照/BIZ/system/config/client.config.m里面的说明开启了多租户,相关表里面的字段也加了,现在可以以多租户的方式登录,但是进去啥菜单也看不见。
我按照控制台的SQL:
SELECT
pm.sFID AS pm_fid,
pm.sFName AS pm_fname,
pm.SFCODE AS pm_fcode,
r. SID,
r.SCODE AS r_sCode,
r.SNAME AS r_sName,
perm1. SID AS perm1,
perm1.sPermissionRoleID AS sPermissionRoleID,
perm1.SPROCESS AS sProcess,
perm1.SACTIVITYFNAME AS sActivityFName,
perm1.SACTIVITY AS sActivity,
perm1.SACTIONSNAMES AS sActionsNames,
perm1.SACTIONS AS sActions,
perm1.SSEMANTICDP AS sSemanticDP,
perm1.SPERMISSIONKIND AS sPermissionKind,
perm1.SDESCRIPTION AS sDescription,
perm1.SSEQUENCE AS sSequence,
perm1.SVALIDSTATE AS sValidState,
perm1. VERSION AS VERSION
FROM
SA_OPOrg pm
LEFT JOIN SA_OPAuthorize au ON (pm.sFID LIKE au.SORGFID || '%')
AND (au.sjy = 'aaa')
JOIN SA_OPRole r ON (
(au.sAuthorizeRoleID = r. SID)
AND (r.SVALIDSTATE = 1)
)
AND (r.sjy = 'aaa')
LEFT JOIN SA_OPPermission perm1 ON (
(
perm1.sPermissionRoleID = r. SID
)
AND (perm1.SVALIDSTATE = 1)
)
AND (perm1.sjy = 'aaa')
WHERE
(
(pm.SVALIDSTATE = 1)
AND (pm.SPERSONID = '')
AND (pm.SORGKINDID = 'psm')
)
AND (pm.sjy = 'aaa')
查询出来是有数据的,理论上权限应该没问题才对,可是我直接拼接URL访问又提示没有权限。怎么办?
|
|