Re: How to determine default tablespace and accessible tablespaces

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Fri, 04 Jun 2004 15:11:58 GMT
Message-ID: <2j0wc.167$9g6.29@nwrdny03.gnilink.net>

"André Hartmann" <andrehartmann_at_hotmail.com> wrote in message news:40c08e0e$1_at_olaf.komtel.net...
> Hi there,
>
> I have an Oracle user account on a 9i instance which is granted roles
> CONNECT and RESOURCE plus UNLIMITED TABLESPACE system right. Now I wonder if
> that user can determine:
>
> (1) What is his default tablespace and default temporary tablespace (user
> cannot select from sys.dba_users --> ORA-00942) ?
> (2) What is the set of tablespaces that there are in the instance (user
> cannot select from sys.dba_tablespaces --> ORA-00942) ?
> (3) What is the set of tablespaces that the user is allowed to create schema
> objects in ?
>
> Thanks a lot,
>
> André
> :)
>
>

Are you aware there are user_* and all_* views too? Thus there exists a user_users view. and a user_tablespaces view.

Anurag Received on Fri Jun 04 2004 - 10:11:58 CDT