oracle8.1.6
select s.synonym_id
from category_synonyms s, categories c
where s.synonym_id in ([join $synonym_id ,])
and c.category_id = s.category_id
and acs_permission.permission_p(c.tree_id,:user_id,'category_tree_write') = 't'
and s.synonym_p = 't'