permission::get_parties_with_permission (public)

 permission::get_parties_with_permission -object_id object_id \
    [ -privilege privilege ]

Defined in packages/acs-tcl/tcl/acs-permissions-procs.tcl

Return a list of lists of party_id and acs_object.title, having a given privilege on the given object

Switches:

-object_id (required)

-privilege (optional, defaults to "admin")

See Also:

• permission::permission_p

Partial Call Graph (max 5 caller/called nodes):

Testcases:

test_inheritance_and_custom_permissions

Source code:

    return [db_list_of_lists get_parties {}]

Generic XQL file:

packages/acs-tcl/tcl/acs-permissions-procs.xql

PostgreSQL XQL file:

<fullquery name="permission::get_parties_with_permission.get_parties">
    <querytext>
        select distinct o.title, p.party_id
        from acs_permission.parties_with_object_privilege(:object_id, :privilege) p, acs_objects o
        where p.party_id = o.object_id
      </querytext>
</fullquery>

packages/acs-tcl/tcl/acs-permissions-procs-postgresql.xql

Oracle XQL file:

<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>

packages/acs-tcl/tcl/acs-permissions-procs-oracle.xql