oracle创建表空间、用户

--1：创建临时表空间
create temporary tablespace spa_authsys_temp  
tempfile 'F:\soft64\ora11g\oradata\orcl\my\authsys_temp.dbf' 
size 50m  
autoextend on  
next 50m maxsize 1024m  
extent management local;  
 
--2：创建数据表空间
create tablespace spa_authsys_data  
logging  
datafile 'F:\soft64\ora11g\oradata\orcl\my\authsys_data.dbf' 
size 50m  
autoextend on  
next 50m maxsize 1024m  
extent management local;  
 
--第3步：创建用户并指定表空间
create user authsys identified by authsys  
default tablespace spa_authsys_data  
temporary tablespace spa_authsys_temp;  
 
--第4步：给用户授予权限
grant connect,resource to authsys;
grant create any sequence to authsys;
grant create any table to authsys;
grant delete any table to authsys;
grant insert any table to authsys;
grant select any table to authsys;
grant unlimited tablespace to authsys;
grant execute any procedure to authsys;
grant update any table to authsys;
grant create any view to authsys;