Oracle 创建用户并分配表空间、权限

2019独角兽企业重金招聘Python工程师标准>>>

-- 1：创建临时表空间
create temporary tablespace tabelspace_temp
tempfile '...\tabelspace_temp.dbf' 
size 50m  
autoextend on  
next 50m maxsize 20480m  
extent management local;  
 
-- 2：创建数据表空间
create tablespace tabelspace_data
logging  
datafile '...\tabelspace_data.dbf' 
size 50m  
autoextend on  
next 50m maxsize 20480m  
extent management local;  
commit;

-- 创建用户并指定表空间
create user username identified by password
default tablespace tabelspace_data
temporary tablespace tabelspace_temp;  
commit;

-- 分配权限
grant connect,resource,dba to username;
commit;

-- 修改用户表空间
alter user username default tablespace tablespace_name

 

转载于:https://my.oschina.net/fengzhi714/blog/1305483