ORACLE创建用户 表空间 临时表空间 并赋予相应权限
用户名 : test4
密码 : kingdee$2016
表空间 : test4
临时表空间 : tmptest4
CREATE TABLESPACE test4;
CREATE TEMPORARY TABLESPACE tmptest4;CREATE USER test4 PROFILE DEFAULT IDENTIFIED BY kingdee$2016 DEFAULT TABLESPACE test4 TEMPORARY TABLESPACE tmptest4 ACCOUNT UNLOCK;
Grant create session ,create table,create sequence to test4;
GRANT UNLIMITED TABLESPACE TO test4;
Grant create session,create table,create procedure,create sequence,create trigger,create view,SELECT ANY DICTIONARY,CREATE MATERIALIZED VIEW,alter profile to test4