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

The closest Oracle concept to those kind of "databases" is schemata. See the Oracle Concepts manual at tahiti.oracle.com so you talkee the right wordees, otherwise people will answer the question you asked.

select unique owner from user_tab_privs;

Will show the schemata.

> my login credentials allow me access to tablespace DATABASE1 and
> DATABASE2, I would like to get such list somehow from some system
> table.

select owner, table_name, privilege from user_tab_privs;

>
> Is this possible without admin rights?

There are a lot of roles and privileges, you can only see that which you have been allowed.

Take a look at all_objects to see what you can see.

desc all_objects

jg

--
@home.com is bogus.
What's in your database?
http://www.signonsandiego.com/uniontrib/20060109/news_1n9pot.html