[Summary view] [Print] [Text view]

   1  /*
   2    This first section is optional, however its probably the best method
   3    of running phpBB on Oracle. If you already have a tablespace and user created
   4    for phpBB you can leave this section commented out!
   5  
   6    The first set of statements create a phpBB tablespace and a phpBB user,
   7    make sure you change the password of the phpBB user before you run this script!!
   8  */
   9  
  10  /*
  11  CREATE TABLESPACE "PHPBB"
  12      LOGGING
  13      DATAFILE 'E:\ORACLE\ORADATA\LOCAL\PHPBB.ora'
  14      SIZE 10M
  15      AUTOEXTEND ON NEXT 10M
  16      MAXSIZE 100M;
  17  
  18  CREATE USER "PHPBB"
  19      PROFILE "DEFAULT"
  20      IDENTIFIED BY "phpbb_password"
  21      DEFAULT TABLESPACE "PHPBB"
  22      QUOTA UNLIMITED ON "PHPBB"
  23      ACCOUNT UNLOCK;
  24  
  25  GRANT ANALYZE ANY TO "PHPBB";
  26  GRANT CREATE SEQUENCE TO "PHPBB";
  27  GRANT CREATE SESSION TO "PHPBB";
  28  GRANT CREATE TABLE TO "PHPBB";
  29  GRANT CREATE TRIGGER TO "PHPBB";
  30  GRANT CREATE VIEW TO "PHPBB";
  31  GRANT "CONNECT" TO "PHPBB";
  32  
  33  COMMIT;
  34  DISCONNECT;
  35  
  36  CONNECT phpbb/phpbb_password;
  37  */