Forum OpenACS Q&A: Response to acs_object_party_privilege_map replacement

Collapse
Posted by Tom Jackson on

Thanks Don. Jeff Davis emailed me with the same advice: use the all_object_party_privilege_map:

> select privilege from all_object_party_privilege_map where
>  object_id = 6282 and party_id = 2581;

Nested Loop  (cost=0.00..30.35 rows=1 width=52)
  ->  Nested Loop  (cost=0.00..17.08 rows=1 width=40)
        ->  Nested Loop  (cost=0.00..15.05 rows=1 width=28)  

I wasn't suggesting throwing the permission system out, not even! I just haven't in this particular case found the reason for the existence of this view, other than to confuse and baffle. If you can't inexpensively select this query, what can this view be used for? I tried specifying the exact privilege as well, but it still had the same cost.