Re: List of tablespaces available for the current user

weboweb_at_hotmail.com wrote:
> Hello everybody,
>
> I'm no Oracle expert, not even newbie level :-)
> I just need to know if it is possible at all to obtain the list of
> tablespaces for the logged-in user.
>
> For example, after I log in to the SQL Plus console and type a command
> such as
>
> SELECT * FROM DBA_TABLESPACES (or whatever sys table has that
> information)
>
> I get table does not exist, obviously because I do not have admin
> priviledges.
> So how can I then find out the tablespaces my login credentials grant
> me access to?
> By tablespaces I mean "databases" coming from SQL server world. So If
> my login credentials allow me access to tablespace DATABASE1 and
> DATABASE2, I would like to get such list somehow from some system
> table.
>
> Is this possible without admin rights?
>
> Thanks all!
>
> webO
>

select * from all_tablespaces;

In fact there's a corresponding ALL_ view for most of the DBA_ views. They show what's accessible to the current user. All these can be found in the docs at http://tahiti.oracle.com.

-- 
To reply by email remove "_nospam"