postgresql7.1
select acs_permission__grant_permission (
:class_id,
:the_public_id,
'read'
);
select acs_permission__revoke_permission (
:class_id,
:the_public_id,
'read'
);
select acs_permission__permission_p(:class_id, oppm.party_id, :privilege) as permission_p,
oppm.party_id
from acs_object_party_privilege_map oppm
where oppm.object_id = :package_id
and oppm.privilege = 'mailing_list_admin'
and oppm.party_id <> :user_id
and acs_permission__permission_p(:package_id, oppm.party_id, 'admin') = 'f'
select acs_permission__grant_permission (
:class_id,
:users_id,
:privilege
);
select acs_permission__revoke_permission (
:class_id,
:users_id,
:privilege
);