久久综合电影,精品免费一区二区三区,精品国产91乱码一区二区三区

View Post

Oracle 創建用戶和表空間腳本

Oracle 創建用戶

DROP USER USER1 CASCADE;

CREATE USER "USER1" PROFILE "DEFAULT"

IDENTIFIED BY "USER1" DEFAULT TABLESPACE "TT_1"

TEMPORARY TABLESPACE "TEMP"

ACCOUNT UNLOCK;

GRANT "CONNECT" TO "USER1";

GRANT "DELETE_CATALOG_ROLE" TO "USER1";

GRANT "EXECUTE_CATALOG_ROLE" TO "USER1";

GRANT "EXP_FULL_DATABASE" TO "USER1";

GRANT "HS_ADMIN_ROLE" TO "USER1";

GRANT "IMP_FULL_DATABASE" TO "USER1";

GRANT "OLAP_USER" TO "USER1";

GRANT "RECOVERY_CATALOG_OWNER" TO "USER1";

GRANT "RESOURCE" TO "USER1";

GRANT "SCHEDULER_ADMIN" TO "USER1";

GRANT "SELECT_CATALOG_ROLE" TO "USER1";

Oracle創建表空間

drop tablespace TT_1 including contents and datafiles cascade constraints;

create tablespace TT_1

datafile '/u02/oradata/tt/tt_1.DBF'

size 50M

autoextend on

next 10M

maxsize UNLIMITED;

posted on 2008-06-30 00:34 MingIsMe 閱讀(212) 評論(0) 編輯收藏所屬分類: 10 Database

Samuel Learning

文章分類(203)

新聞分類(52)

.NET資源

Ajax

Java開源

Mobile

WEB資源

Workflow

其他連接

大牛人

開源軟件

敏捷

數據庫

未歸類

經典框架

網絡教程

著名站點

項目管理

最新評論

View Post

Oracle 創建用戶和表空間腳本