--
-- revoke_permission/3
--
create or replace function revoke_permission(
  p_object_id integer,
  p_grantee_id integer,
  p_privilege character varying
) returns int4 as $$

DECLARE
BEGIN
    delete from acs_permissions
    where object_id = p_object_id
    and grantee_id = p_grantee_id
    and privilege = p_privilege;

    return 0; 
END;
$$ language plpgsql;