grant select on dba_* - whatever DBA_ view you want that person to have access to.

dba_data_files being the most likely one in this case.



sys@ORA9IR2> create user a identified by a;

User created.

sys@ORA9IR2> grant create session to a;

Grant succeeded.

sys@ORA9IR2> grant select on dba_data_files to a;

Grant succeeded.

sys@ORA9IR2>
sys@ORA9IR2> @connect a/a
sys@ORA9IR2> set termout off
a@ORA9IR2>
a@ORA9IR2> set termout on
a@ORA9IR2> select tablespace_name, sum(bytes/1024/1024) mbytes
2 from dba_data_files
3 group by tablespace_name;

TABLESPACE_NAME MBYTES
------------------------------ ----------
BIG_TABLE 140
CWMLITE 20
DRSYS 20
EXAMPLE 148.75
INDX 25
ODM 20
SYSTEM 480
TEST 104
TOOLS 10
UNDOTBS1 405
USERS 1213.75
XDB 45

12 rows selected.