Trigger name changes

[lhc/web/wiklou.git] / maintenance / oracle / user.sql

diff --git a/maintenance/oracle/user.sql b/maintenance/oracle/user.sql
index d54acf3..0a36ac4 100644 (file)
--- a/maintenance/oracle/user.sql
+++ b/maintenance/oracle/user.sql
@@ -1,8 +1,8 @@
 -- defines must comply with ^define\s*([^\s=]*)\s*=\s?'\{\$([^\}]*)\}';
 define wiki_user='{$wgDBuser}';
 define wiki_pass='{$wgDBpassword}';
-define def_ts='{$wgDBOracleDefTS}';
-define temp_ts='{$wgDBOracleTempTS}';
+define def_ts='{$_OracleDefTS}';
+define temp_ts='{$_OracleTempTS}';
 
 create user &wiki_user. identified by &wiki_pass. default tablespace &def_ts. temporary tablespace &temp_ts. quota unlimited on &def_ts.;
 grant connect, resource to &wiki_user.;
@@ -14,3 +14,5 @@ grant create synonym to &wiki_user.;
 grant create table to &wiki_user.;
 grant create sequence to &wiki_user.;
 grant create trigger to &wiki_user.;
+grant create type to &wiki_user.;
+grant create procedure to &wiki_user.;