conn /as sysdba
revoke select on all_db_links from public;
conn test/test
select * from all_db_links;
select * from all_db_links
*
ERROR 位于第 1 行:
ORA-00942: 表或视图不存在
revoke select on all_db_links from public;
conn test/test
select * from all_db_links;
select * from all_db_links
*
ERROR 位于第 1 行:
ORA-00942: 表或视图不存在
即可