在Infor Syteline ERP系统中,没有一个很好的管理介面,可以根据forms名,查找到其所归属的安全组。为什么会有这样需求呢?因为在权限管理中,某个安全组包含了哪些forms,或者哪些forms归属于哪个安全组中,为了这个方便管理,Insus.NET写了一段SQL语句:
SELECT
[
GroupId
],
[
GroupName
],
[
GroupDesc
],
[
ObjectName1
],
[
ObjectName2
]
FROM
[
dbo
].
[
GroupNames
]
AS gn
RIGHT JOIN [ dbo ]. [ AccountAuthorizations ] AS aa ON (gn. [ GroupId ] = aa. [ Id ])
WHERE [ ObjectName1 ] LIKE ' %???% '
RIGHT JOIN [ dbo ]. [ AccountAuthorizations ] AS aa ON (gn. [ GroupId ] = aa. [ Id ])
WHERE [ ObjectName1 ] LIKE ' %???% '
上面的???地方,在查询时填写forms 名。如查看AuditLog 窗口归属哪一个安全组,执行如下: