oracle 数据库创建表空间和用户及用户间赋权限

一、搜索出表空间存储位置

select tablespace_name,file_id,bytes/1024/1024,file_name 
　　 from dba_data_files order by file_id;

二、创建表空间和用户

--创建表空间
CREATE TABLESPACE usertry
LOGGING 
DATAFILE 'C:\APP\ADMINISTRATOR\ORADATA\ORCL\usertry.DBF'
SIZE 64M
AUTOEXTEND ON;
commit;
--创建临时表空间
CREATE temporary TABLESPACE usertry_TEMP
TEMPFILE 'C:\APP\ADMINISTRATOR\ORADATA\ORCL\usertry_TEMP.DBF'
SIZE 64M
AUTOEXTEND ON;
commit;

--创建usertry用户
CREATE USER usertry
IDENTIFIED BY usertry
DEFAULT TABLESPACE usertry TEMPORARY TABLESPACE usertry_TEMP
ACCOUNT UNLOCK;
commit;
--授于usertry用户相应权限
GRANT CREATE ANY SEQUENCE TO usertry;
GRANT CREATE ANY TABLE TO usertry;
GRANT ENQUEUE ANY QUEUE TO usertry;
GRANT UNLIMITED TABLESPACE TO usertry;
GRANT CONNECT TO usertry;
GRANT DBA TO usertry;
GRANT RECOVERY_CATALOG_OWNER TO usertry;
GRANT RESOURCE TO usertry;
commit;

三、用户赋权限

grant connect,resource,alter system,debug connect session,select any table,delete any table,drop any table,alter any table to usertry;