Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to get database names without login in as DBA
chalesx_at_yahoo.com (Hugh Xie) wrote in message news:<48854e4d.0106260651.44621904_at_posting.google.com>...
> I am trying list the database names for a given server via JDBC.
> However, I do not have privs to 'sys'. So I can not do 'select name from
> v$database'. Is there anyother way? Thanks in advance.
I believe that you need the select_catalog_role role in order to select from the v$database view, or even better, select privilege on the v$database view. Received on Tue Jun 26 2001 - 15:21:32 CDT