ORACLE创建用户 表空间 临时表空间 并赋予相应权限

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