Index: openacs-4/contrib/packages/simulation/sql/postgresql/simulation-drop.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/simulation/sql/postgresql/Attic/simulation-drop.sql,v diff -u -r1.13 -r1.14 --- openacs-4/contrib/packages/simulation/sql/postgresql/simulation-drop.sql 1 Dec 2003 14:50:33 -0000 1.13 +++ openacs-4/contrib/packages/simulation/sql/postgresql/simulation-drop.sql 1 Dec 2003 15:15:08 -0000 1.14 @@ -199,6 +199,13 @@ perform acs_privilege__remove_child(''sim_object_writer'',''sim_object_write''); perform acs_privilege__remove_child(''admin'',''sim_admin''); + perform acs_privilege__drop_privilege(''sim_object_write''); + perform acs_privilege__drop_privilege(''sim_object_create''); + perform acs_privilege__drop_privilege(''sim_object_writer''); + perform acs_privilege__drop_privilege(''sim_set_map_p''); + perform acs_privilege__drop_privilege(''sim_template_create''); + perform acs_privilege__drop_privilege(''sim_inst''); + perform acs_privilege__drop_privilege(''sim_admin''); return null; end;' language 'plpgsql'; Index: openacs-4/contrib/packages/simulation/sql/postgresql/simulation-privs-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/simulation/sql/postgresql/Attic/simulation-privs-create.sql,v diff -u -r1.3 -r1.4 --- openacs-4/contrib/packages/simulation/sql/postgresql/simulation-privs-create.sql 1 Dec 2003 14:50:33 -0000 1.3 +++ openacs-4/contrib/packages/simulation/sql/postgresql/simulation-privs-create.sql 1 Dec 2003 15:15:08 -0000 1.4 @@ -1,4 +1,13 @@ --- privileges +-- privileges +select acs_privilege__create_privilege('sim_admin','',null); +select acs_privilege__create_privilege('sim_template_create','',null); +select acs_privilege__create_privilege('sim_inst','',null); +select acs_privilege__create_privilege('sim_set_map_p','',null); +select acs_privilege__create_privilege('sim_object_writer','',null); +select acs_privilege__create_privilege('sim_object_create','',null); +select acs_privilege__create_privilege('sim_object_write','',null); + +-- add children select acs_privilege__add_child('admin','sim_admin'); select acs_privilege__add_child('sim_admin','sim_template_create'); select acs_privilege__add_child('sim_admin','sim_inst'); Index: openacs-4/packages/simulation/sql/postgresql/simulation-drop.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/simulation/sql/postgresql/simulation-drop.sql,v diff -u -r1.13 -r1.14 --- openacs-4/packages/simulation/sql/postgresql/simulation-drop.sql 1 Dec 2003 14:50:33 -0000 1.13 +++ openacs-4/packages/simulation/sql/postgresql/simulation-drop.sql 1 Dec 2003 15:15:08 -0000 1.14 @@ -199,6 +199,13 @@ perform acs_privilege__remove_child(''sim_object_writer'',''sim_object_write''); perform acs_privilege__remove_child(''admin'',''sim_admin''); + perform acs_privilege__drop_privilege(''sim_object_write''); + perform acs_privilege__drop_privilege(''sim_object_create''); + perform acs_privilege__drop_privilege(''sim_object_writer''); + perform acs_privilege__drop_privilege(''sim_set_map_p''); + perform acs_privilege__drop_privilege(''sim_template_create''); + perform acs_privilege__drop_privilege(''sim_inst''); + perform acs_privilege__drop_privilege(''sim_admin''); return null; end;' language 'plpgsql'; Index: openacs-4/packages/simulation/sql/postgresql/simulation-privs-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/simulation/sql/postgresql/simulation-privs-create.sql,v diff -u -r1.3 -r1.4 --- openacs-4/packages/simulation/sql/postgresql/simulation-privs-create.sql 1 Dec 2003 14:50:33 -0000 1.3 +++ openacs-4/packages/simulation/sql/postgresql/simulation-privs-create.sql 1 Dec 2003 15:15:08 -0000 1.4 @@ -1,4 +1,13 @@ --- privileges +-- privileges +select acs_privilege__create_privilege('sim_admin','',null); +select acs_privilege__create_privilege('sim_template_create','',null); +select acs_privilege__create_privilege('sim_inst','',null); +select acs_privilege__create_privilege('sim_set_map_p','',null); +select acs_privilege__create_privilege('sim_object_writer','',null); +select acs_privilege__create_privilege('sim_object_create','',null); +select acs_privilege__create_privilege('sim_object_write','',null); + +-- add children select acs_privilege__add_child('admin','sim_admin'); select acs_privilege__add_child('sim_admin','sim_template_create'); select acs_privilege__add_child('sim_admin','sim_inst');