UFN_PART_UPDATEPERMISSION

create function dbo.UFN_PART_UPDATEPERMISSION(
      @USERID     int
)
returns table
 As 
 Return
 (
     Select SC.ID from dbo.CMSOBJETSECURITYEXCEPTION OSE  
            inner join dbo.CMSOBJECTTASK OT on OSE.OBJECTTASKID = OT.ID  
            inner join dbo.ClientRoles CR on CR.Guid = OSE.EXCEPTIONOBJECTGUID  
            inner join dbo.SiteContent SC on SC.Guid = OSE.SECUREDOBJECTGUID 
            inner join (Select [ID] As roleId,[Name] As roleName from dbo.fnUserMembership(@USERID) where member = 1) As UserRole 
                        on UserRole.roleID = CR.ID
            where OT.ENUMID = 1
     Union

     Select ID from SiteContent where OwnerID = @USERID

     Union 

     Select -1 As ID

 )