oralce 表空间 建立 授权
时间:2017-01-17 21:53 来源:linux.it.net.cn 作者:IT
/*第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)
| /*第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) |