USP_ROLESYNC_GETAPPUSERLIST

Gets a list of APPUSER records to be processed by the RoleSync utility.

Definition

Copy


            create procedure dbo.USP_ROLESYNC_GETAPPUSERLIST
            as
            --Used by the RoleSync utility

            set nocount on;

            select USERSID, DISPLAYNAME
            from dbo.APPUSER

            WHERE APPUSER.USERSID is not null