22,209
社区成员
发帖
与我相关
我的任务
分享
SELECT dbo.SystemUser.userID, dbo.SystemUser.userAccount, dbo.SystemRole.roleID, dbo.SystemRole.roleDesc, dbo.SystemPermission.permissionID,
dbo.SystemPermission.permissionDesc
FROM dbo.SystemUser INNER JOIN
dbo.SystemU2R ON dbo.SystemUser.userID = dbo.SystemU2R.userID INNER JOIN
dbo.SystemRole ON dbo.SystemU2R.roleID = dbo.SystemRole.roleID INNER JOIN
dbo.SystemR2P ON dbo.SystemRole.roleID = dbo.SystemR2P.roleID INNER JOIN
dbo.SystemPermission ON dbo.SystemR2P.permissionID = dbo.SystemPermission.permissionID
WHERE SystemUser.userID=10