preset.cmd

set CSsys=system/123@ORASQL
system -     Oracle (   )
123 -   
ORASQL -      tnsnames.ora

---------------------------------
fossdoc.sql
DB_Name -   
db_user -  
password -    


SET FLUSH ON
SPOOL fossdoc.log

DROP TABLESPACE DB_Name INCLUDING CONTENTS AND DATAFILES;

CREATE TABLESPACE DB_Name
    DATAFILE 'DB_Name.ora' SIZE 100M AUTOEXTEND ON NEXT 250M EXTENT MANAGEMENT LOCAL;

DROP USER db_user CASCADE;

CREATE USER db_user IDENTIFIED BY password
  DEFAULT TABLESPACE DB_Name TEMPORARY TABLESPACE temp
  QUOTA UNLIMITED ON DB_Name;

@Grants.sql

EXIT;

---------------------------------
Grants.sql
db_user -    ,   ,    fossdoc.sql


GRANT CREATE SESSION TO db_user
/
GRANT CREATE TABLE TO db_user
/
GRANT CREATE PROCEDURE TO db_user
/
GRANT CREATE TRIGGER TO db_user
/
GRANT CREATE VIEW TO db_user
/
GRANT CREATE SEQUENCE TO db_user
/
GRANT CREATE VIEW TO db_user
/
GRANT CREATE TYPE TO db_user
/


GRANT DELETE ANY TABLE TO db_user
/
GRANT DROP ANY TABLE TO db_user
/
GRANT DROP ANY PROCEDURE TO db_user
/
GRANT DROP ANY TRIGGER TO db_user
/
GRANT DROP ANY VIEW TO db_user
/
GRANT DROP ANY TYPE TO db_user
/


GRANT ALTER ANY TABLE TO db_user
/
GRANT ALTER ANY TABLE TO db_user
/
GRANT ALTER ANY PROCEDURE TO db_user
/
GRANT ALTER ANY TRIGGER TO db_user
/
GRANT ALTER ANY TYPE TO db_user
/
GRANT EXECUTE ON CTX_DDL TO db_user
/
-- DEBUG

grant dba to db_user
/

grant select on v_$session to db_user
/

GRANT ALTER session TO db_user
/

