USP_DATALIST_CLIENTUSERS_OWNEDSECURABLEOBJECTS

Returns the ObjectGuid for every Securable Object owned by the specified user
Parameters

Parameter	Parameter Type	Mode	Description
@CLIENTUSERSID	int	IN	Input parameter indicating the context ID for the data list.
Definition

Copy


CREATE procedure dbo.USP_DATALIST_CLIENTUSERS_OWNEDSECURABLEOBJECTS(@CLIENTUSERSID int)
as
    set nocount on;

            select 
                GUID as OBJECTGUID                
            from dbo.SiteContent
            where OwnerID = @CLIENTUSERSID

            UNION ALL
            select
                GUID as OBJECTGUID
            from dbo.SitePages
            where TemplatePageID != 0 and OwnerID = @CLIENTUSERSID

            UNION ALL
            select
                GUID as OBJECTGUID
            from dbo.SitePages
            where TemplatePageID = 0 and OwnerID = @CLIENTUSERSID

            UNION ALL
            select
                GUID as OBJECTGUID
            from dbo.SiteImages
            where OwnerID = @CLIENTUSERSID

            UNION ALL
            select
                GUID as OBJECTGUID
            from dbo.ClientSites
            where OwnerID = @CLIENTUSERSID

            UNION ALL
            select
                GUID as OBJECTGUID
            from dbo.EmailList
            where OwnerID = @CLIENTUSERSID

            UNION ALL
            select
                GUID as OBJECTGUID
            from dbo.EmailTemplate
            where OwnerID = @CLIENTUSERSID            

            UNION ALL
            select
                O.GUID as OBJECTGUID
            from dbo.DocUploadPart O
            INNER JOIN dbo.SiteContent sc on O.SiteContentID = sc.ID
            where sc.OwnerID = @CLIENTUSERSID

            UNION ALL
            select
                O.GUID as OBJECTGUID
            from dbo.DiscussionGroups O
            INNER JOIN dbo.SiteContent sc on O.SiteContentID = sc.ID
            where sc.OwnerID = @CLIENTUSERSID

            UNION ALL
            select
                O.GUID as OBJECTGUID
            from dbo.JobBoards O
            INNER JOIN dbo.SiteContent sc on O.SiteContentID = sc.ID
            where sc.OwnerID = @CLIENTUSERSID

            UNION ALL
            select
                O.GUID as OBJECTGUID
            from dbo.GivingHistory O
            INNER JOIN dbo.SiteContent sc on O.SiteContentID = sc.ID
            where sc.OwnerID = @CLIENTUSERSID

            UNION ALL
            select
                O.GUID as OBJECTGUID
            from dbo.NewsReaders O
            INNER JOIN dbo.SiteContent sc on O.SiteContentID = sc.ID
            where sc.OwnerID = @CLIENTUSERSID

            UNION ALL
            select
                O.GUID as OBJECTGUID
            from dbo.NewsChannels O
            INNER JOIN dbo.SiteContent sc on O.SiteContentID = sc.ID
            where sc.OwnerID = @CLIENTUSERSID

            UNION ALL
            select
                GUID as OBJECTGUID
            from dbo.SiteStylesheets
            where OwnerID = @CLIENTUSERSID

            UNION ALL
            select
                O.CalendarCategoryPicksID as OBJECTGUID
            from dbo.CalendarEvtCategoryPicks O
            inner join dbo.EventCalendar ec on O.EventCalendarID = ec.ID
            inner join dbo.SiteContent sc on ec.SiteContentID = sc.ID
            where sc.OwnerID = @CLIENTUSERSID

            UNION ALL
            select
                GUID as OBJECTGUID
            from dbo.EmailProject
            where OwnerID = @CLIENTUSERSID