Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to get database names without login in as DBA

Re: How to get database names without login in as DBA

From: Dan Murphy <djmurphy0_at_hotmail.com>
Date: 26 Jun 2001 13:21:32 -0700
Message-ID: <577749aa.0106261221.3d0deaae@posting.google.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US