Fabien COELHO wrote: > Please find attached as somehow requested a plpgsql implementation > for a "high-level description" (by that, I understand "relationnal", > not "functionnal") of acl in postgres.
That doesn't tell me anything. The functionality of the ACL system is to answer questions like "does user X have privilege Y on object Z". It seems that this question can be answered using existing facilities. Additionally we have information schema views that list existing privileges, and those views are defined using existing facilities. It appears that your tables mostly duplicate that. Can you say in words what information you are missing? ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend