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.3.2.4 -r1.3.2.5
--- openacs-4/packages/acs-kernel/sql/oracle/acs-create.sql	4 Jul 2003 12:22:36 -0000	1.3.2.4
+++ openacs-4/packages/acs-kernel/sql/oracle/acs-create.sql	6 Aug 2003 17:58:54 -0000	1.3.2.5
@@ -267,7 +267,8 @@
   -- Create the public group
   foo := acs_group.new (
     group_id => -1,
-    group_name => 'The Public'
+    group_name => 'The Public',
+    join_policy => 'closed'
   );
 
   insert into acs_magic_objects
@@ -288,7 +289,8 @@
 
   foo := acs_group.new (
     group_id => -2,
-    group_name => 'Registered Users'
+    group_name => 'Registered Users',
+    join_policy => 'closed'
   );
 
  insert into acs_magic_objects
Index: openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-4.6.5-4.6.6.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-4.6.5-4.6.6.sql,v
diff -u -r1.1.2.1 -r1.1.2.2
--- openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-4.6.5-4.6.6.sql	4 Jul 2003 12:22:36 -0000	1.1.2.1
+++ openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-4.6.5-4.6.6.sql	6 Aug 2003 17:58:54 -0000	1.1.2.2
@@ -1,13 +1,10 @@
 -- 
 -- @author Lars Pind (lars@collaboraid.biz)
 -- @creation-date 2003-07-03
--- 
--- Add 'admin_rel' relationship type for administrators of a group
---
--- Make object_id 0 ("Unregistered Visitor") a user, not a person.
---
 
+-- Make groups registered users and the public closed (security)
 
+update groups set join_policy = 'closed' where group_id in (-1,-2);
 
 -- Make object_id 0 ("Unregistered Visitor") a user, not a person.
 
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.6.4.6 -r1.6.4.7
--- openacs-4/packages/acs-kernel/sql/postgresql/acs-create.sql	4 Jul 2003 12:22:36 -0000	1.6.4.6
+++ openacs-4/packages/acs-kernel/sql/postgresql/acs-create.sql	6 Aug 2003 17:58:54 -0000	1.6.4.7
@@ -238,7 +238,7 @@
     null,
     null,
     ''The Public'',
-    null,
+    ''closed'',
     null
   );
 
@@ -285,7 +285,7 @@
     null,
     null,
     ''Registered Users'',
-    null,
+    ''closed'',
     null
   );
 
Index: openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-4.6.5-4.6.6.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-4.6.5-4.6.6.sql,v
diff -u -r1.1.2.1 -r1.1.2.2
--- openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-4.6.5-4.6.6.sql	4 Jul 2003 12:22:37 -0000	1.1.2.1
+++ openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-4.6.5-4.6.6.sql	6 Aug 2003 17:58:54 -0000	1.1.2.2
@@ -1,13 +1,10 @@
 -- 
 -- @author Lars Pind (lars@collaboraid.biz)
 -- @creation-date 2003-07-03
--- 
--- Add 'admin_rel' relationship type for administrators of a group
---
--- Make object_id 0 ("Unregistered Visitor") a user, not a person.
---
 
+-- Make groups registered users and the public closed (security)
 
+update groups set join_policy = 'closed' where group_id in (-1,-2);
 
 -- Make object_id 0 ("Unregistered Visitor") a user, not a person.