acs-permissions-procs-oracle.xql

DB Query file
File Contents

<?xml version="1.0"?>

<queryset>
   <rdbms><type>oracle</type><version>8.1.6</version></rdbms>

    <fullquery name="permission::grant.grant_permission">
        <querytext>
            declare
            begin
                acs_permission.grant_permission(
                    object_id => :object_id,
                    grantee_id => :party_id,
                    privilege => :privilege
                );
            end;
        </querytext>
    </fullquery>

    <fullquery name="permission::revoke.revoke_permission">
        <querytext>
            declare
            begin
                acs_permission.revoke_permission(
                    object_id => :object_id,
                    grantee_id => :party_id,
                    privilege => :privilege
                );
            end;
        </querytext>
    </fullquery>

    <fullquery name="permission::toggle_inherit.toggle_inherit">
        <querytext>
            update acs_objects
            set security_inherit_p = case when security_inherit_p = 't'
                                          then 'f'
                                          else 't'
                                     end
            where object_id = :object_id
        </querytext>
    </fullquery>

    <fullquery name="permission::get_parties_with_permission.get_parties">
      <querytext>
        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	
      </querytext>
    </fullquery>

</queryset>
acs-permissions-procs-oracle.xql

Related Files

File Contents
