Re: How to determine default tablespace and accessible tablespaces

Hi André,

It is totally possible for a single user with few rigths to have information on him self.

There are in Oracle 4 kinds of views

=> DBA_XXX
=> ALL_XXX
=> USER_XXX
=> V$

if you make a select on user_users, you will find the answer to question 1.

Same if you make a select on user_tablespaces, it will answer to question 2.

For question 3, I think you will find it and user_XXX view as well but I do not remember which one.

Regs,

Olivier

"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é
> :)
Received on Fri Jun 04 2004 - 15:39:34 CDT