UFN_SECUREDCHILDQUERYVIEW_GETSECUREDQUERYNAMES

Gets the list of secured child query view names.

Return

Return Type
table

Definition

Copy



            create function dbo.UFN_SECUREDCHILDQUERYVIEW_GETSECUREDQUERYNAMES()
            returns table
            as
            return (
                select 
                    QUERYVIEWCATALOG.OBJECTNAME
                from 
                    dbo.SECUREDCHILDQUERYVIEW inner join
                    dbo.QUERYVIEWCATALOG on SECUREDCHILDQUERYVIEW.ID = QUERYVIEWCATALOG.ID)