Re: List of tablespaces available for the current user

"Chuck" <skilover_nospam_at_bluebottle.com> a écrit dans le message de news: jqAwf.27464$v84.4183_at_trnddc06...
| 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"

I don't think all_tablespaces exists:

SQL> desc all_tablespaces
ERROR:
ORA-04043: object all_tablespaces does not exist

Regards
Michel Cadot Received on Mon Jan 09 2006 - 15:28:09 CST