ORACLE 新增用户

1、创建用户： 

 create user eptc identified by eptc123 default tablespace users temporary tablespace temp;

2、授权：

  grant connect , resource , imp_full_database to eptc;

3、使用户空间无限量

  

  alter user eptc quota unlimited on users;

CREATE TABLESPACE eptc

    LOGGING 

    DATAFILE 'D:\oradata\eptc\data01.dbf' SIZE 1024M REUSE 

    AUTOEXTEND 

    ON NEXT  128K MAXSIZE  32767M DEFAULT STORAGE ( INITIAL 64K 

    NEXT 0K MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 ) 

    MINIMUM EXTENT 64K;