Depends on who you are and what you can do.


SQL> conn sys/oracle@db00
Connected.
SQL> grant select on v$database to scott;
grant select on v$database to scott
*
ERROR at line 1:
ORA-02030: can only select from fixed tables/views


SQL> grant select on dba_data_files to scott;

Grant succeeded.

SQL> connect system/manager@db00
Connected.
SQL> grant select on dba_users to scott;
grant select on dba_users to scott
*
ERROR at line 1:
ORA-01031: insufficient privileges;