maintenance/ora/user.sql

   1 define WIKI_USER=&1
   2 define WIKI_PASS=&2
   3 define DEF_TS=&3
   4 define TEMP_TS=&4
   5 create user &&wiki_user identified by &&wiki_pass default tablespace &&def_ts temporary tablespace &&temp_ts quota unlimited on &&def_ts;
   6 grant connect, resource to &&wiki_user;
   7 grant alter session to &&wiki_user;
   8 grant ctxapp to &&wiki_user;
   9 grant execute on ctx_ddl to &&wiki_user;
  10 grant create view to &&wiki_user;
  11 grant create synonym to &&wiki_user;
  12 grant create table to &&wiki_user;
  13 grant create sequence to &&wiki_user;