> 数据库 > Oracle >

oralce 表空间 建立 授权

/*第1步:创建临时表空间  */
create temporary tablespace cmmobispace_temp  
tempfile 'C:\tablespace\cmmobispace_temp.dbf'
size 50m 
autoextend on 
next 50m maxsize 10480m 
extent management local;

/*第2步:创建数据表空间  */

create tablespace cmmobispace 
logging 
datafile 'C:\tablespace\cmmobispace.dbf'
size 50m 
autoextend on 
next 50m maxsize 10480m 
extent management local;

/**给用户表空间授予权限**/
CREATE USER oagw2 IDENTIFIED BY oagw2
DEFAULT TABLESPACE cmmobispace
TEMPORARY TABLESPACE cmmobispace_temp;

/**给用户操作授予权限**/
GRANT
  CREATE SESSION, CREATE ANY TABLE, CREATE ANY VIEW ,CREATE ANY INDEX, CREATE ANY PROCEDURE,
  ALTER ANY TABLE, ALTER ANY PROCEDURE,
  DROP ANY TABLE, DROP ANY VIEW, DROP ANY INDEX, DROP ANY PROCEDURE,
  SELECT ANY TABLE, INSERT ANY TABLE, UPDATE ANY TABLE, DELETE ANY TABLE
  TO username;

/**授权 dba**
grant connect,resource,dba to oagw2;

(责任编辑:IT)