NOTE: Prior to Oracle 10g R2, DocuShare used the Connect role to create the tablespace. Oracle 10g R2 changed the permission privileges for the Connect role. This change in role privileges requires DocuShare 4.x to have Connect, Create Table, and Create Sequence roles granted.
The following sample script should be run by the Oracle DBA to create the tablespace and user with the roles required for DocuShare.
REM Replace the values in the define statement with appropriate values.
REM For creating user and tablespaces
define tbs_name=Docushare
define datafile = C:\oracle\oradata\Docushare.dbf
define tmp_tbs = Docushare_tmp
define tmp_datafile = C:\oracle\oradata\Docushare_tmp.dbf
define user_name = Docushare
define user_pwd = password
CREATE TABLESPACE &tbs_name
LOGGING
DATAFILE '&datafile' SIZE 100M REUSE
AUTOEXTEND ON NEXT 512K MAXSIZE 2560M
EXTENT MANAGEMENT LOCAL AUTOALLOCATE;
CREATE TEMPORARY TABLESPACE &tmp_tbs
TEMPFILE '&tmp_datafile' SIZE 20M REUSE
AUTOEXTEND ON NEXT 512K MAXSIZE 2560M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 512K;
CREATE USER &user_name
IDENTIFIED BY &user_pwd
DEFAULT TABLESPACE &tbs_name
TEMPORARY TABLESPACE &tmp_tbs
QUOTA UNLIMITED ON &tbs_name;
GRANT CONNECT, CREATE TABLE, CREATE SEQUENCE TO &user_name;