通過創建視圖及同義詞方式實現普通用戶查詢X$基表的方法

SQL> show user
USER is "SYS"
SQL> select count(*) from sys.x$kcbwds;

 COUNT(*)
----------
 8

SQL> CREATE PUBLIC SYNONYM kcbwds FOR sys.x$kcbwds;

Synonym created.

SQL> grant select on sys.x$kcbwds to bys;
grant select on sys.x$kcbwds to bys
 *
ERROR at line 1:
ORA-02030: can only select from fixed tables/views
----------
SQL> show user
USER is "BYS"
SQL> select count(*) from sys.x$kcbwds;
select count(*) from sys.x$kcbwds
 *
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> select count(*) from kcbwds;
select count(*) from kcbwds
 *
ERROR at line 1:
ORA-00942: table or view does not exist

SQL> show user
USER is "SYS"
SQL> select count(*) from x$kcbwds;

 COUNT(*)
----------
 8
SQL> create view testa as select * from sys.x$kcbwds;

View created.

SQL> grant select on sys.testa to bys;

Grant succeeded.

SQL> conn bys/bys
Connected.
SQL> show user
USER is "BYS"
SQL> select count(*) from sys.testa;

 COUNT(*)
----------
 8
SQL> desc sys.testa
 Name Null? Type
 ----------------------------------------- -------- ----------------------------
 ADDR RAW(4)
 INDX NUMBER
 INST_ID NUMBER
 SET_ID NUMBER
 POOL_ID NUMBER
 DBWR_NUM NUMBER
 BLK_SIZE NUMBER
后面省略。。

SQL> CREATE PUBLIC SYNONYM testb FOR sys.testa;

Synonym created.

SQL> show user
USER is "SYS"
SQL> conn / as sysdba
Connected.
SQL> conn bys/bys
Connected.
SQL> select count(*) from testb;

 COUNT(*)
----------
 8