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:

Partial Call Graph (max 5 caller/called nodes):
%3 test_test_inheritance_and_custom_permissions test_inheritance_and_custom_permissions (test acs-tcl) permission::get_parties_with_permission permission::get_parties_with_permission test_test_inheritance_and_custom_permissions->permission::get_parties_with_permission db_list_of_lists db_list_of_lists (public) permission::get_parties_with_permission->db_list_of_lists acs_admin::posture_status acs_admin::posture_status (private) acs_admin::posture_status->permission::get_parties_with_permission

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

[ hide source ] | [ make this the default ]
Show another procedure: