Представление (естественно пример для понимания)

Create view Accesses as 
Select ObjectId from AccessTable where Allow=1

Запрос:

With SearchQuery AS (
Select ObjectId from Table1 where ...
) , SearchQueryExt (
Select * from SearchQuery 
union Select ObjectId from Table2 where .... 
union Select ObjectId from Table3 where ....
), FilterQuery (
Select * 
   fom SearchQueryExt s 
  join Accesses a on a.ObjectId = s.ObjectId
)
Select * 
  from TableN s
  join FilterQuery f on s.ObjectId = f.ObjectId

Create function Accesses (ObjctIds ????)
Select ObjectId 
  from AccessTable 
 where ObjetId in ObjctIds 
   and Allow=1

А FilterQuery  поменять на что-то вроде :

.
.
.
), FilterQuery (
Select * 
   fom SearchQueryExt s 
  join dbo.fAccesses(select ObjectId from SearchQuery) on a.ObjectId = s.ObjectId
)
.
.
.