Index: openacs-4/packages/forums/sql/oracle/forums-search-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/sql/oracle/forums-search-create.sql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/forums/sql/oracle/forums-search-create.sql	11 Jul 2002 14:28:27 -0000	1.2
+++ openacs-4/packages/forums/sql/oracle/forums-search-create.sql	12 Jul 2002 15:20:54 -0000	1.3
@@ -71,6 +71,7 @@
 show errors
 
 grant execute on s_index_message to yon;
+grant execute on ctx_ddl to yon;
 
 -- as normal user
 connect yon/yon;
@@ -83,15 +84,12 @@
     indextype is ctxsys.context
     parameters ('datastore forums_user_datastore');
 
--- as ctxsys
-connect ctxsys/ctxsys;
-
 declare
     v_job                           number;
 begin
     dbms_job.submit(
         job => v_job,
-        what => 'ctxsys.ctx_ddl.sync_index(''yon.forums_content_idx'');',
+        what => 'ctxsys.ctx_ddl.sync_index(''forums_content_idx'');',
         interval => 'sysdate + 1/24'
     );
 end;
Index: openacs-4/packages/forums/sql/oracle/forums-search-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/sql/oracle/forums-search-drop.sql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/forums/sql/oracle/forums-search-drop.sql	11 Jul 2002 14:28:27 -0000	1.2
+++ openacs-4/packages/forums/sql/oracle/forums-search-drop.sql	12 Jul 2002 15:20:54 -0000	1.3
@@ -33,9 +33,6 @@
 drop function im_convert;
 drop procedure im_convert_length_check;
 
--- as ctxsys
-connect ctxsys/ctxsys;
-
 declare
 begin
     for row in (select job
@@ -48,9 +45,6 @@
 /
 show errors
 
--- as normal user
-connect yon/yon;
-
 drop index forums_content_idx;
 
 execute ctx_ddl.unset_attribute('forums_user_datastore', 'procedure');