- , - , dbo.SystemFormBase dbo.UserFormBase .
- , PrincipalObjectAccess.
sp, , .
[dbo]. [GetDashboardIds]
( @SystemUserID uniqueidentifier
)
FormId "DashboardID", "Name", "Name", "System" DashboardType
dbo.SystemFormBase
Type = 0
Union
UserFormId 'DashboardID', Name 'Name', 'Custom' DashboardType
dbo.UserFormBase
Type = 0 OwnerId = @systemUserID
UserFormId 'DashboardID', Name 'Name', 'Custom' DashboardType
from dbo.UserFormBase UFB PrincipalObjectAccess POA UFB.UserFormId = ObjectId
Type = 0 POA.PrincipalId = @systemUserID