revoke select any table from user_name; grant select table_name to user_name;
你看到的都是些公用的对象, SQL> create user test identified by test default tablespace si;User created.SQL> grant connect to test;Grant succeeded.SQL> conn test/test@jj Connected. SQL> select * from dba_data_files; select * from dba_data_files * ERROR at line 1: ORA-00942: table or view does not exist
是不是有select any table的权限.
grant select table_name to user_name;
SQL> create user test identified by test default tablespace si;User created.SQL> grant connect to test;Grant succeeded.SQL> conn test/test@jj
Connected.
SQL> select * from dba_data_files;
select * from dba_data_files
*
ERROR at line 1:
ORA-00942: table or view does not exist