oracle创建表空间并授权用户

create temporary tablespace zilaike_TEMP 

tempfile'E:\app\Administrator\oradata\orcl\zilaike_TEMP.dbf' 

size 50m  

autoextend on  

next 50m maxsize 20480m  

extent management local;  

 

create tablespace zilaike  

logging  

datafile'E:\app\Administrator\oradata\orcl\zilaike.dbf' 

size 50m  

autoextend on  

next 50m maxsize 20480m  

extent management local;  

 

create user zilaike identified by　zilaike

default tablespace   zilaike

temporary tablespace zilaike_TEMP;  

 

grant connect,resource,dba to zilaike ;

==========for  ubuntu docker    alexeiled/docker-oracle-xe-11g ============

/*如何查看oracle表空间数据文件位置*/

/*select file_name , tablespace_name from dba_data_files;*/

create temporary tablespace PMP_TEMP  

tempfile '/u01/app/oracle/oradata/XE/PMP_TEMP.dbf' 

size 50m  

autoextend on  

next 50m maxsize 20480m  

extent management local;  

 

create tablespace PMP  

logging  

datafile '/u01/app/oracle/oradata/XE/PMP.dbf' 

size 50m  

autoextend on  

next 50m maxsize 20480m  

extent management local;  

 

create user PMP identified by　PMP_1234

default tablespace   PMP

temporary tablespace PMP_TEMP;  

 

grant connect,resource,dba to PMP ;

//====================others=====================================

CREATE USER INFA IDENTIFIED BY INFA DEFAULT TABLESPACE SYSTEM TEMPORARY TABLESPACE TEMP PROFILE DEFAULT ACCOUNT UNLOCK;
GRANT CONNECT TO INFA;
GRANT RESOURCE TO INFA;
GRANT CREATE VIEW TO INFA;
GRANT UNLIMITED TABLESPACE TO INFA;
GRANT SELECT ANY TABLE TO INFA;
ALTER USER INFA DEFAULT ROLE ALL;
COMMIT;