Maximo7.6系統安裝報告11

Create tablespace maxdata datafile ‘D:\Oracle\oradata\maximo\maxdata.dbf’ size 1000M autoextend on;

Create tablespace maxindex datafile ‘D:\Oracle\oradata\maximo\maxindex.dbf’ size 1000M autoextend on;

create temporary tablespace maxtemp tempfile ‘D:\Oracle\oradata\maximo\maxtemp.dbf’ size 500M autoextend on maxsize unlimited;

create user maximo identified by maximo default tablespace maxdata temporary tablespace maxtemp;

alter user maximo quota unlimited on maxindex;

grant connect to maximo;

grant create job to maximo;

grant create trigger to maximo;

grant create session to maximo;

grant create sequence to maximo;

grant create synonym to maximo;

grant create table to maximo;

grant create view to maximo;

grant create procedure to maximo;

grant alter session to maximo;

grant execute on ctxsys.ctx_ddl to maximo;

alter user maximo quota unlimited on maxdata;

–grant create user to MAXIMO;

–grant drop user to MAXIMO;

–grant create session to MAXIMO with ADMIN OPTION;

–grant alter user to MAXIMO;