create user itsm identified by dhccitsmdefault tablespace trunk_datatemporary tablespace trunk_temp;
授权
GRANTCREATE SESSION, CREATE ANY TABLE, CREATE ANY VIEW ,CREATE ANY INDEX, CREATE ANYPROCEDURE,ALTER ANY TABLE, ALTER ANY PROCEDURE,DROP ANY TABLE, DROP ANY VIEW, DROP ANY INDEX, DROP ANY PROCEDURE,SELECT ANY TABLE, INSERT ANY TABLE, UPDATE ANY TABLE, DELETE ANY TABLETO itsm;
create temporary tablespace trunk_temp
tempfile '/opt/oracle/oradata/trunk_temp.dbf'
size 50m
autoextend on
next 50m maxsize 2048m
extent management local;
create tablespace trunk_data
logging
datafile '/opt/oracle/oradata/trunk_data.dbf'
size 50m
autoextend on
next 50m maxsize 2048m
extent management local;
create user itsm identified by dhccitsm
default tablespace trunk_data
temporary tablespace trunk_temp;
GRANT
CREATE SESSION, CREATE ANY TABLE, CREATE ANY VIEW ,CREATE ANY INDEX, CREATE ANY
PROCEDURE,
ALTER ANY TABLE, ALTER ANY PROCEDURE,
DROP ANY TABLE, DROP ANY VIEW, DROP ANY INDEX, DROP ANY PROCEDURE,
SELECT ANY TABLE, INSERT ANY TABLE, UPDATE ANY TABLE, DELETE ANY TABLE
TO itsm;