Index: openacs-4/packages/acs-kernel/sql/oracle/acs-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/acs-create.sql,v diff -u -r1.20 -r1.21 --- openacs-4/packages/acs-kernel/sql/oracle/acs-create.sql 26 Sep 2006 14:48:02 -0000 1.20 +++ openacs-4/packages/acs-kernel/sql/oracle/acs-create.sql 27 Oct 2007 22:10:59 -0000 1.21 @@ -240,14 +240,15 @@ acs_privilege.create_privilege('admin'); acs_privilege.create_privilege('annotate'); - --------------------------------------------------------- - -- Administrators can read, write, create, and delete. -- - --------------------------------------------------------- + ------------------------------------------------------------------- + -- Administrators can read, write, create, delete, and annotate. -- + ------------------------------------------------------------------- acs_privilege.add_child('admin', 'read'); acs_privilege.add_child('admin', 'write'); acs_privilege.add_child('admin', 'create'); acs_privilege.add_child('admin', 'delete'); + acs_privilege.add_child('admin', 'annotate'); commit; end; Index: openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.4.0d3-5.4.0d4.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.4.0d3-5.4.0d4.sql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.4.0d3-5.4.0d4.sql 27 Oct 2007 22:10:59 -0000 1.1 @@ -0,0 +1,6 @@ +begin + acs_privilege.add_child('admin', 'annotate'); + commit; +end; +/ +show errors Index: openacs-4/packages/acs-kernel/sql/postgresql/acs-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/acs-create.sql,v diff -u -r1.36 -r1.37 --- openacs-4/packages/acs-kernel/sql/postgresql/acs-create.sql 25 Sep 2006 17:59:16 -0000 1.36 +++ openacs-4/packages/acs-kernel/sql/postgresql/acs-create.sql 27 Oct 2007 22:10:59 -0000 1.37 @@ -230,14 +230,15 @@ select acs_privilege__create_privilege('admin', null, null); select acs_privilege__create_privilege('annotate', null, null); - --------------------------------------------------------- - -- Administrators can read, write, create, and delete. -- - --------------------------------------------------------- + ------------------------------------------------------------------- + -- Administrators can read, write, create, delete, and annotate. -- + ------------------------------------------------------------------- select acs_privilege__add_child('admin', 'read'); select acs_privilege__add_child('admin', 'write'); select acs_privilege__add_child('admin', 'create'); select acs_privilege__add_child('admin', 'delete'); + select acs_privilege__add_child('admin', 'annotate'); end; Index: openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.4.0d3-5.4.0d4.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.4.0d3-5.4.0d4.sql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.4.0d3-5.4.0d4.sql 27 Oct 2007 22:10:59 -0000 1.1 @@ -0,0 +1 @@ +select acs_privilege__add_child('admin', 'annotate');