Index: openacs-4/packages/dotlrn/sql/oracle/dotlrn-security-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/sql/oracle/Attic/dotlrn-security-create.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/dotlrn/sql/oracle/dotlrn-security-create.sql	29 Nov 2001 03:44:21 -0000	1.1
@@ -0,0 +1,56 @@
+
+--
+-- dotLRN Project
+--
+-- copyright 2001, OpenForce
+-- released under the GPL, v2.0
+--
+-- ben@openforce
+--
+-- 11/28/2001
+--
+-- Security Setup for dotLRN
+-- privileges, privilege inheritance
+--
+
+DECLARE
+BEGIN
+	-- the ability to even view that a community exists
+	acs_privilege.create_privilege('dotlrn_view_community');
+
+	-- the ability to participate in a community
+	acs_privilege.create_privilege('dotlrn_edit_community');
+
+	-- the ability to admin a community
+	acs_privilege.create_privilege('dotlrn_admin_community');
+
+	-- the ability to create a community
+	acs_privilege.create_privilege('dotlrn_create_community');
+
+	-- the ability to even view a community type
+	acs_privilege.create_privilege('dotlrn_view_community_type');
+
+	-- the ability to admin a community type
+	acs.privilege.create_privilege('dotlrn_admin_community_type');
+	
+	-- the ability to create a community type
+	acs_privilege.create_privilege('dotlrn_create_community_type');
+
+	-- Consistent permissions
+	acs_privilege.add_child('dotlrn_edit_community', 'dotlrn_view_community');
+	acs_privilege.add_child('dotlrn_admin_community', 'dotlrn_edit_community');
+
+	-- inheritance
+	acs_privilege.add_child('create', 'dotlrn_create_community_type');
+	acs_privilege.add_child('create', 'dotlrn_create_community');
+	acs_privilege.add_child('edit', 'dotlrn_edit_community');
+	acs_privilege.add_child('read', 'dotlrn_view_community');
+	acs_privilege.add_child('read', 'dotlrn_view_community_type');
+	acs_privilege.add_child('admin', 'dotlrn_admin_community');
+	acs_privilege.add_child('admin', 'dotlrn_admin_community_type');
+
+	-- no default permissions
+
+end;
+/
+show errors