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);
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);