Re: Data files in a tablespace.

Praveen wrote:

> Hi..All,
>
> I am using DBA studio to look at the oracle data dictionary . I
> connect as a normal user with out any DBA privileges & yet I am able to
> see the data file(s) associated to a particular table's tablespace. I
> thought the data files can only be viewed when you get connected as a DBA.
> So, from which table does the DBA Studio retrieve the data files list ?
>
> I am using Oracle 8i.
>
> TIA
>
>
> P

The view dba_data_files as well as the views dba_temp_files and dba_free_space are visible to anyone with the appropriate privilege. There is on such thing as a normal user. What privileges and roles have been granted to the userid you are using?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)