Re: reports 6 system variables
From: sybrandb <sybrandb_at_gmail.com>
Date: 13 Dec 2006 03:42:10 -0800
Message-ID: <1166010130.269666.8790_at_l12g2000cwl.googlegroups.com>
Date: 13 Dec 2006 03:42:10 -0800
Message-ID: <1166010130.269666.8790_at_l12g2000cwl.googlegroups.com>
On Dec 13, 11:27 am, "Ronald" <rmolev..._at_gmail.com> wrote:
> Hi all,
>
> Is there any way to retrieve the used userid/password_at_database as
> variable in the report itself ?
> I want to have a bit different report if it is connected to database X
> then Y
>
> thanks in advance,
>
> Ronald.
Look up sys_context('userenv'...) in the sql reference manual. IIRC the password can not be retrieved, and this sounds *very* reasonable.
-- Sybrand Bakker Senior Oracle DBAReceived on Wed Dec 13 2006 - 12:42:10 CET