Access to v$views

[pnrdba]

Shandj is correct,

SQL> grant select any table to dloader;

Grant succeeded.

SQL> select name from v$database;

NAME
---------
CMSRPT1

SQL> select count(*) from dba_tablespaces;

COUNT(*)
----------
20

SQL> select count(*) from dba_data_files;

COUNT(*)
----------
60

Its working for any v$tables and dba_tables....


Thanks