本文共 1888 字，大约阅读时间需要 6 分钟。

Oracle?????????

?Oracle??????????????????DBA??????????????????????????????????????????????????Oracle?????????????

1. ?????

?Oracle??????????????????????????????

CREATE TABLESPACE UNLIMITED_TABLESPACE

???????????UNLIMITED_TABLESPACE?????????????????????????????????

2. ??????

?Oracle????????????????????????????????????????

• CONNECT? ????????????
• RESOURCE? ???????????????

CREATE SESSION AS farthest

?????????????????

3. ????

?Oracle??????GRANT?????????????????????

• CONNECT? ?????????
• RESOURCE? ???????????
• CREATE? ???????????
• ALTER? ?????????
• DELETE? ????????
• UPDATE? ????????
• INSERT? ?????????
• REFERENCES? ??????????
• FLASHBACK? ??????????
• DEBUG? ???????????
• QUERY REWRITE? ?Oracle?????
• ON COMMIT REFRESH? ???????????

???????????

GRANT CONNECT, RESOURCE TO Zhang;

4. ????

?Oracle??????REVOKE???????????????????????

• CONNECT? ?????????
• RESOURCE? ???????????
• CREATE? ??????????????
• ALTER? ????????????
• DELETE? ???????????
• UPDATE? ???????????
• INSERT? ????????????
• REFERENCES? ?????????????
• FLASHBACK? ?????????????
• DEBUG? ??????????????
• QUERY REWRITE? ??Oracle???????
• ON COMMIT REFRESH? ??????????????

???????????

REVOKE CONNECT, RESOURCE FROM Chenmh;

5. ???????????

?Oracle????????SQL??????????????????SQL????

SELECT 'GRANT SELECT, DELETE, UPDATE, INSERT ON '||OWNER||'.'||TABLE_NAME||' TO Chenmh;'FROM dba_tablesWHERE OWNER = 'Zhang';

6. ???????????

?Oracle????????SQL??????????????????SQL????

SELECT 'REVOKE '||PRIVILEGE||' FROM Chenmh;'FROM DBA_SYS_PRIVSWHERE GRANTEE = 'Chenmh';

7. ????????????

?Oracle????????SQL???????????????????SQL????

SELECT 'REVOKE '||GRANTED_ROLE||' FROM Chenmh;'FROM DBA_ROLE_PRIVSWHERE GRANTEE = 'Chenmh';

8. ?????????????

?Oracle????????SQL????????????????????SQL????

SELECT 'REVOKE '||PRIVILEGE||' ON '||OWNER||'.'||TABLE_NAME||' FROM Chenmh;'FROM DBA_Tab_PrivsWHERE GRANTEE = 'Chenmh'ORDER BY TABLE_NAME, PRIVILEGE;

??????????????Oracle???????????????????????