Re: List of tablespaces available for the current user

Joel Garry wrote:
> 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

Thanks very much everybody!
You've provided me the right answers.

webO Received on Tue Jan 10 2006 - 08:09:12 CST