select acs_permission__permission_p(aggregator_id,:user_id,'write') as write_p
from na_aggregators
select a.aggregator_name
from na_aggregators a,
acs_objects o
where o.object_id = a.aggregator_id
and a.aggregator_id != :aggregator_id
and o.creation_user = :user_id
select s.title, s.source_id
from na_sources s
where source_id not in (select source_id
from na_subscriptions
where aggregator_id = :aggregator_id)