Comment 1 for bug 1469594

Revision history for this message
Aaron Wells (u-aaronw) wrote :

So with this setup, the query to get the list of pages you have access to would look like this:

select v.* from {view} v where exists (select 1 from {view_access_cache} vac where vac.viewid = v.id and vac.usr = ? or vac.public=1 or vac.loggedin=1);