select count(*) from acs_privileges where privilege = :privilege select case when security_inherit_p = 't' then 1 else 0 end from acs_objects where object_id = :object_id update acs_objects set security_inherit_p = 't' where object_id = :object_id update acs_objects set security_inherit_p = 'f' where object_id = :object_id select 1 from dual where exists ( select 1 from acs_object_party_privilege_map ppm where ppm.object_id = :object_id and ppm.party_id = :party_id and ppm.privilege = :privilege )