From 9db190c7e736ec8d063187d4241b59feaf7dc2d1 Mon Sep 17 00:00:00 2001
From: Pierre Schmitz <pierre@archlinux.de>
Date: Wed, 22 Jun 2011 11:28:20 +0200
Subject: update to MediaWiki 1.17.0

---
 maintenance/oracle/user.sql | 16 ++++++++++++++++
 1 file changed, 16 insertions(+)
 create mode 100644 maintenance/oracle/user.sql

(limited to 'maintenance/oracle/user.sql')

diff --git a/maintenance/oracle/user.sql b/maintenance/oracle/user.sql
new file mode 100644
index 00000000..57688eae
--- /dev/null
+++ b/maintenance/oracle/user.sql
@@ -0,0 +1,16 @@
+-- defines must comply with ^define\s*([^\s=]*)\s*=\s?'\{\$([^\}]*)\}';
+define wiki_user='{$wgDBuser}';
+define wiki_pass='{$wgDBpassword}';
+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.;
+grant alter session to &wiki_user.;
+grant ctxapp to &wiki_user.;
+grant execute on ctx_ddl to &wiki_user.;
+grant create view to &wiki_user.;
+grant create synonym to &wiki_user.;
+grant create table to &wiki_user.;
+grant create sequence to &wiki_user.;
+grant create trigger to &wiki_user.;
-- 
cgit v1.2.2

