ITPub博客

首页 > 数据库 > Oracle > Oracle数据库创建表空间与用户

Oracle数据库创建表空间与用户

Oracle 作者:kristy_2005 时间:2010-12-03 16:55:30 0 删除 编辑
CREATE TABLESPACE "QONEYILONG" LOGGING DATAFILE 'G:oracleproduct10.2.0oradataqoneyilongqoneyilong.ora' SIZE 500M EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

CREATE temporary tablespace "QONEYILONG_TEMP" tempfile 'G:oracleproduct10.2.0oradataqoneyilongqoneyilong_temp.ora' SIZE 100M EXTENT MANAGEMENT LOCAL;

create user root identified by root default tablespace qone temporary tablespace qone_temp;

grant dba to root;

grant connect,resource,create view to root;

GRANT CONNECT, RESOURCE, CREATE VIEW, CREATE PUBLIC SYNONYM TO root WITH ADMIN OPTION;

GRANT ALTER ANY ROLE, ALTER ANY SEQUENCE,ALTER ANY TABLE, ALTER TABLESPACE, ALTER ANY TRIGGER,COMMENT ANY TABLE, CREATE ANY SEQUENCE, CREATE ANY TABLE,CREATE ANY TRIGGER, CREATE ROLE, CREATE TABLESPACE,CREATE USER, DROP ANY SEQUENCE, DROP ANY TABLE,DROP ANY TRIGGER, DROP TABLESPACE, DROP USER,DROP ANY ROLE, GRANT ANY ROLE, INSERT ANY TABLE,SELECT ANY TABLE, UPDATE ANY TABLE TO root;
<!-- 正文结束 -->

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/21162344/viewspace-1117349/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 没有了~
下一篇: 没有了~
请登录后发表评论 登录
全部评论

注册时间:2009-03-20