oracle8.1.6
declare
begin
acs_permission.grant_permission(
object_id => :object_id,
grantee_id => :party_id,
privilege => :privilege
);
end;
declare
begin
acs_permission.revoke_permission(
object_id => :object_id,
grantee_id => :party_id,
privilege => :privilege
);
end;
update acs_objects
set security_inherit_p = case when security_inherit_p = 't'
then 'f'
else 't'
end
where object_id = :object_id
select distinct o.title, p.party_id
from acs_object_party_privilege_map p, acs_objects o
where p.object_id = :object_id and p.privilege = :privilege and o.object_id = p.party_id