Re: August PL/SQL Tip of the Month: SQL*Plus Prompt Change

From: Jurij Modic <jmodic_at_src.si>
Date: Wed, 18 Aug 1999 20:38:38 GMT
Message-ID: <37bd131d.4556386_at_news.siol.net>

On Wed, 18 Aug 1999 12:39:57 -0500, "Dennis" <dennis_at_bearclaws.com> wrote:

>FYI,
>I had to do a
>grant select_catalog_role to user
>from SYS to get this to work.

You could simply grant select only on V$DATABASE, no need to grant a whole role just for getting database name out of the dictionary. Or even simpler, instead of using V$DATABASE, you can use GLOBAL_NAME view, which is publicly available. You can use SUBSTR and INSTR functions if you want to strip out the domain part of the global name and use only a database name.

HTH,
Jurij Modic <jmodic_at_src.si>
Certified Oracle DBA (7.3 & 8.0 OCP)

---

The above opinions are mine and do not represent any official standpoints of my employer Received on Wed Aug 18 1999 - 22:38:38 CEST