Index: openacs-4/contrib/packages/simulation/sql/postgresql/simulation-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/simulation/sql/postgresql/Attic/simulation-create.sql,v diff -u -r1.2 -r1.3 --- openacs-4/contrib/packages/simulation/sql/postgresql/simulation-create.sql 14 Oct 2003 13:58:03 -0000 1.2 +++ openacs-4/contrib/packages/simulation/sql/postgresql/simulation-create.sql 1 Dec 2003 13:07:12 -0000 1.3 @@ -10,3 +10,4 @@ \i simulation-tables-create.sql \i simulation-content-types-create.sql \i simulation-packages-create.sql +\i simulation-privs-create.sql 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.10 -r1.11 --- openacs-4/contrib/packages/simulation/sql/postgresql/simulation-drop.sql 28 Nov 2003 12:55:45 -0000 1.10 +++ openacs-4/contrib/packages/simulation/sql/postgresql/simulation-drop.sql 1 Dec 2003 13:07:12 -0000 1.11 @@ -184,3 +184,21 @@ ); +---------------------------------------------------------------------- +-- privileges +---------------------------------------------------------------------- + +create function inline_0 () +returns integer as ' +begin + perform acs_privilege__drop_privilege(''sim_template_create''); + perform acs_privilege__drop_privilege(''sim_inst''); + perform acs_privilege__drop_privilege(''sim_object_create''); + perform acs_privilege__drop_privilege(''sim_object_write''); + perform acs_privilege__drop_privilege(''sim_set_map_p''); + + return null; +end;' language 'plpgsql'; + +select inline_0(); +drop function inline_0 (); 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 --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/packages/simulation/sql/postgresql/simulation-privs-create.sql 1 Dec 2003 13:07:12 -0000 1.1 @@ -0,0 +1,7 @@ +-- privileges + +select acs_privilege__create_privilege('sim_template_create','Can create and edit sim templates',null); +select acs_privilege__create_privilege('sim_inst','Can instantiate a sim template into a simulation and edit the simulation',null); +select acs_privilege__create_privilege('sim_object_create','Can create global sim objects',null); +select acs_privilege__create_privilege('sim_object_write','Can change other people''s sim objects',null); +select acs_privilege__create_privilege('sim_set_map_p','Can set and un-set on_map_p for any sim object',null); Index: openacs-4/packages/simulation/sql/postgresql/simulation-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/simulation/sql/postgresql/simulation-create.sql,v diff -u -r1.2 -r1.3 --- openacs-4/packages/simulation/sql/postgresql/simulation-create.sql 14 Oct 2003 13:58:03 -0000 1.2 +++ openacs-4/packages/simulation/sql/postgresql/simulation-create.sql 1 Dec 2003 13:07:12 -0000 1.3 @@ -10,3 +10,4 @@ \i simulation-tables-create.sql \i simulation-content-types-create.sql \i simulation-packages-create.sql +\i simulation-privs-create.sql 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.10 -r1.11 --- openacs-4/packages/simulation/sql/postgresql/simulation-drop.sql 28 Nov 2003 12:55:45 -0000 1.10 +++ openacs-4/packages/simulation/sql/postgresql/simulation-drop.sql 1 Dec 2003 13:07:12 -0000 1.11 @@ -184,3 +184,21 @@ ); +---------------------------------------------------------------------- +-- privileges +---------------------------------------------------------------------- + +create function inline_0 () +returns integer as ' +begin + perform acs_privilege__drop_privilege(''sim_template_create''); + perform acs_privilege__drop_privilege(''sim_inst''); + perform acs_privilege__drop_privilege(''sim_object_create''); + perform acs_privilege__drop_privilege(''sim_object_write''); + perform acs_privilege__drop_privilege(''sim_set_map_p''); + + return null; +end;' language 'plpgsql'; + +select inline_0(); +drop function inline_0 (); 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 --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/simulation/sql/postgresql/simulation-privs-create.sql 1 Dec 2003 13:07:12 -0000 1.1 @@ -0,0 +1,7 @@ +-- privileges + +select acs_privilege__create_privilege('sim_template_create','Can create and edit sim templates',null); +select acs_privilege__create_privilege('sim_inst','Can instantiate a sim template into a simulation and edit the simulation',null); +select acs_privilege__create_privilege('sim_object_create','Can create global sim objects',null); +select acs_privilege__create_privilege('sim_object_write','Can change other people''s sim objects',null); +select acs_privilege__create_privilege('sim_set_map_p','Can set and un-set on_map_p for any sim object',null);