创建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;
转：/lyjjq/articles/99167.html
posted on -10-15 17:06 老杨~ 阅读(...) 评论(...) 编辑 收藏
