OpenACS

peterm
committed
MAIN:peterm:20031216155947
on 16 Dec 03
adding the sim_role_group_map for casting groups in roles
/postgresql/simulation-privs-drop.sql (+31)
  1 -- @author joel@collaboraid.net
  2 -- @creation-date 2003-10-12
  3 -- @cvs-id $Id$
  4
  5 ----------------------------------------------------------------------
  6 -- privileges
  7 ----------------------------------------------------------------------
  8
  9 create function inline_0 ()
  10 returns integer as '
  11 begin
  12     perform acs_privilege__remove_child(''sim_admin'',''sim_template_create'');
  13     perform acs_privilege__remove_child(''sim_admin'',''sim_inst'');
  14     perform acs_privilege__remove_child(''sim_admin'',''sim_object_writer'');
  15     perform acs_privilege__remove_child(''sim_admin'',''sim_set_map_p'');
  16     perform acs_privilege__remove_child(''sim_object_writer'',''sim_object_create'');
  17     perform acs_privilege__remove_child(''sim_object_writer'',''sim_object_write'');
  18     perform acs_privilege__remove_child(''admin'',''sim_admin'');
  19
  20     perform acs_privilege__drop_privilege(''sim_object_write'');
  21     perform acs_privilege__drop_privilege(''sim_object_create'');
  22     perform acs_privilege__drop_privilege(''sim_object_writer'');
  23     perform acs_privilege__drop_privilege(''sim_set_map_p'');
  24     perform acs_privilege__drop_privilege(''sim_template_create'');
  25     perform acs_privilege__drop_privilege(''sim_inst'');
  26     perform acs_privilege__drop_privilege(''sim_admin'');
  27     return null;
  28 end;' language 'plpgsql';
  29
  30 select inline_0();
  31 drop function inline_0 ();