Oracle?Щ???????
???????????? ???????[ 2016/10/28 10:13:17 ] ????????????? Oracle
???????Oracle??????????Oracle?Щ????????????????????:
????1????????????????б?(??????)
????select table_name from user_tables;
????2?????Oracle?????е????????????DBA
????select * from system_privilege_map order by name;
????3?????Oracle???е??????????DBA;
????select * from dba_roles;
????4?????Oracle?????ж??????
????select distinct privilege from dba_tab_privs;
????5??????????????
????select tablespace_name from dba_tablespaces;
????6??????????????????????????
????select * from user_sys_privs
????7????????????????????????????????????????
????select * from user_tab_privs;--?????????
????select * from user_col_privs;--????????е????
????8??????????????????????
????select * from dba_role_privs where grantee='?????';--???????д
????9????????????????Щ?????
????select * from dba_sys_privs where grantee='DBA';
????select * from role_sys_privs where role='DBA';
????10??????????????????????
????select * from dba_tab_privs where grantee='?????';
????11???????????е??????????
????select granted_role??default_role from dba_role_privs where grantee='?????';--???????д
??????
???·???
??????????????????
2023/3/23 14:23:39???д?ò??????????
2023/3/22 16:17:39????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???·???????·
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11