Index: openacs-4/packages/acs-kernel/sql/postgresql/acs-permissions-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/acs-permissions-create.sql,v diff -u -r1.39.2.5 -r1.39.2.6 --- openacs-4/packages/acs-kernel/sql/postgresql/acs-permissions-create.sql 6 Jul 2016 13:47:02 -0000 1.39.2.5 +++ openacs-4/packages/acs-kernel/sql/postgresql/acs-permissions-create.sql 6 Jul 2016 18:10:13 -0000 1.39.2.6 @@ -659,6 +659,16 @@ -- -- procedure acs_permission.permissions_all/1 -- +-- Return the permissions for an object from the object context +-- hierarchy. The call +-- +-- select * from acs_permission.permissions_all(:object_id) +-- +-- is compatible with the old/Oracle call +-- +-- select * from acs_permission_all where where object_id = :object_id +-- +-- CREATE OR REPLACE FUNCTION acs_permission.permissions_all( p_object_id integer ) RETURNS table (object_id integer, grantee_id integer, privilege varchar) AS $$