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.7 -r1.8 --- openacs-4/packages/forums/sql/oracle/forums-search-create.sql 3 Oct 2003 18:26:31 -0000 1.7 +++ openacs-4/packages/forums/sql/oracle/forums-search-create.sql 13 Oct 2003 07:47:52 -0000 1.8 @@ -57,24 +57,24 @@ show errors -- as ctxsys -connect ctxsys/catssuck; +connect ctxsys/ctxsys; create or replace procedure s_index_message ( rid in rowid, tlob in out NOCOPY clob ) is begin - openacs_4_ora.index_message(rid, tlob); + yon.index_message(rid, tlob); end; / show errors -grant execute on s_index_message to openacs_4_ora; -grant execute on ctx_ddl to openacs_4_ora; +grant execute on s_index_message to yon; +grant execute on ctx_ddl to yon; -- as normal user -connect openacs_4_ora/catssuck; +connect yon/yon; execute ctx_ddl.create_preference('forums_user_datastore', 'user_datastore'); execute ctx_ddl.set_attribute('forums_user_datastore', 'procedure', 's_index_message'); @@ -97,7 +97,7 @@ show errors -- as normal user -connect openacs_4_ora/catssuck; +connect yon/yon; -- ripped off from site-wide-search @@ -264,8 +264,3 @@ end; / show errors; - - --- LARS TODO: --- update apm_parameters ... set UseIntermediaForSearchP = 1 for all forums instances ? --- or set some other flag somehow