返回数说广场
2
--创建一个表空间作为用户的默认表空间,然后授予最小化基础权限。
基础权限如下:
CREATE TABLESPACE JIEKEXU DATAFILE '+DATA' SIZE 32766M UNIFORM SIZE 1M;
CREATE USER JIEKEXU IDENTIFIED BY JIEKEXU DEFAULT TABLESPACE JIEKEXU QUOTA UNLIMITED ON JIEKEXU TEMPORARY TABLESPACE TEMP;
GRANT CREATE SESSION TO JIEKEXU;
GRANT CREATE table TO JIEKEXU;
GRANT CREATE VIEW TO JIEKEXU;
GRANT CREATE TRIGGER TO JIEKEXU;
GRANT CREATE database link TO JIEKEXU;
GRANT CREATE public database link TO JIEKEXU;
GRANT CREATE PROCEDURE to JIEKEXU;
GRANT CREATE sequence to JIEKEXU;
GRANT CREATE synonym to JIEKEXU;
GRANT CREATE any directory to JIEKEXU;
GRANT CREATE JOB to JIEKEXU;
GRANT CREATE MATERIALIZED VIEW to JIEKEXU;
0
2 150
分享
评论
热门数说




