深入浅出Oracle数据库安全知识.pptVIP

* SQL create user maclean_priv identified by oracle; User created. SQL grant connect ,select any table to maclean_priv; Grant succeeded. SQL conn maclean_priv/oracle Connected. SQL select count(*) from sys.obj$; select count(*) from sys.obj$ * ERROR at line 1: ORA-00942: table or view does not exist SQL alter system set O7_DICTIONARY_ACCESSIBILITY=TRUE scope=spfile; System altered. Reboot instance SQL conn maclean_priv/oracle Connected. SQL select count(*) from sys.obj$; COUNT(*) ---------- 52140 * * * * SQL alter session set events 10046 trace