Re: Data files in a tablespace.

This is not necessarily the case. You can select from the dictionary with less powerful privileges than the DBA role. Some things that come to mind are: SELECT_CATALOG_ROLE and even direct select grants on the dba_*/user_*/all_* views (somewhat bad practice).

Try to determine what privs your DBA studio user has. One easy way is to

select * from session_roles;
select * from session_privs;

when you're connected as that user.

Hth.

Praveen <nospam_at_nospam.com> wrote in message news:<cjk8di$qvr$1_at_news1brm.Central.Sun.COM>...
> 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
Received on Fri Oct 01 2004 - 20:17:57 CDT