develog

[oracle] Data Dictionary 본문

카테고리 없음

[oracle] Data Dictionary

냐옴 2019. 9. 20. 17:34

 

SELECT * FROM ALL_ALL_TABLES;

SELECT * FROM DBA_TAB_PRIVS;
SELECT * FROM ALL_TAB_PRIVS;
SELECT * FROM USER_TAB_PRIVS;

SELECT * FROM DBA_COL_PRIVS;
SELECT * FROM ALL_COL_PRIVS;
SELECT * FROM USER_COL_PRIVS;

SELECT * FROM ROLE_ROLE_PRIVS;
SELECT * FROM ROLE_SYS_PRIVS;
SELECT * FROM ROLE_TAB_PRIVS;

SELECT * FROM DBA_OBJECTS;
SELECT * FROM ALL_OBJECTS;
SELECT * FROM USER_OBJECTS;

 

 

https://docs.oracle.com/cd/E11882_01/server.112/e40540/datadict.htm#CNCPT2140

 

Data Dictionary and Dynamic Performance Views

This chapter describes the central set of read-only reference tables and views of each Oracle database, known collectively as the data dictionary. The chapter also describes the dynamic performance views, which are special views that are continuously updat

docs.oracle.com

 

저작자표시 비영리 동일조건 (새창열림)
Comments