創建oracle 數據庫表空間，角色，用戶的sql語句

1.創建角色

CREATE ROLE "QIUDINGROLE" NOT IDENTIFIED;

GRANT "CONNECT" TO "QIUDINGROLE";
GRANT "DBA" TO "QIUDINGROLE";
GRANT "RESOURCE" TO "QIUDINGROLE";

2.創建表空間
CREATE SMALLFILE TABLESPACE "DIAOCHA" DATAFILE 'D:\oracle\product\10.1.0\oradata\qiuding\diaocha' SIZE 100M AUTOEXTEND ON NEXT 1M MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

BEGIN DBMS_SERVER_ALERT.SET_THRESHOLD(9000,NULL,NULL,NULL,NULL,1,1,NULL,5,'DIAOCHA'); END;

CREATE SMALLFILE TEMPORARY TABLESPACE "DIAOCHA_TEMP" TEMPFILE 'D:\oracle\product\10.1.0\oradata\qiuding\diaocha_temp' SIZE 100M AUTOEXTEND ON NEXT 1M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;

BEGIN DBMS_SERVER_ALERT.SET_THRESHOLD(9000,NULL,NULL,NULL,NULL,1,1,NULL,5,'DIAOCHA_TEMP'); END;

?3.創建用戶
create user QIUDING
? identified by "QIUDING"
? default tablespace "DIAOCHA"
? temporary tablespace "DIAOCHA_TEMP"
? profile DEFAULT
? ACCOUNT UNLOCK;

grant QIUDINGROLE to QIUDING;
grant unlimited tablespace to QIUDING

4.創建備份目錄并且付相應權限
create directory dump_dir as 'D:\oracle\backup';
grant read,write on directory dump_dir to QIUDING;

?

轉：http://www.blogjava.net/lyjjq/articles/99167.html

posted on 2010-10-15 17:06 老楊~ 閱讀(...) 評論(...) 編輯 收藏

轉載于:https://www.cnblogs.com/qiangqiang/archive/2010/10/15/1852396.html

總結

以上是生活随笔為你收集整理的创建oracle 数据库表空间，角色，用户的sql语句的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。