This stored procedure returns all of the authorized security roles for the specified tab and module. This single list of roles is used to control edit access for a specific module.
Definition:CREATE PROCEDURE GetAuthRoles ( @PortalID int, @ModuleID int, @AccessRoles nvarchar (256) OUTPUT, @EditRoles nvarchar (256) OUTPUT ) AS SELECT @AccessRoles = Tabs.AuthorizedRoles, @EditRoles = Modules.AuthorizedEditRoles FROM Modules INNER JOIN Tabs ON Modules.TabID = Tabs.TabID WHERE Modules.ModuleID = @ModuleID AND Tabs.PortalID = @PortalIDDatabase Tables Used:
Tabs: Each record in the Tabs table defines the name and access permissions for a tab in the selected portal.
The primary key in this table is the TabID identity field.
The primary key in this table is the ModuleID identity field.