Re: Getting Username, Password and Oracle instance name.

[Krishnan Sarangarajan <ksaranga@RUAN.COM>]

Christian - As far as the username goes, you can use "$username" variable.
This is a reserved variable within an SQR.

As far as the Oracle instance name goes, you can select against PSDBOWNER to
get the name of the instance. In reality, if your shop were to have 2
instances of Oracle, the PSDBOWNER table could have the names of both the
instances.

The best case scenario would be to make sure that only the name of the
respective instance appears in PSDBOWNER. If all else fails, you could
always select against "v$database" to get the name of the database.

If I have confused you, please feel free to give me a call and I will happy
to help you out.

As far as the password goes, there may be a way to extract it from the
database, given a username. That would be a question for your DBA.

Hope this helps...

Sincerely,
Krishnan

Ruan Transportation Management Systems
(515) 245-5655 [P]
(515) 247-2065 [F]
ksaranga@ruan.com



-----Original Message-----
From: Ray Ontko [mailto:rayo@ONTKO.COM]
Sent: Thursday, November 04, 1999 12:45 PM
To: Multiple recipients of list SQR-USERS
Subject: Re: Getting Username, Password and Oracle instance name.


Christian,

Not as far as I know.  If you're using oracle, you can
get the current username from:

begin-select
user  &user
from dual
end-select

Ray

> Is there a mean from within a SQR report to get the user name, the
password
> et the Instance name of the current database we are logging on?
>
> In other words, is there a mean to get the command line parameter
discribing
> this informations (i.e. PDupont/cmy45xq@ora_orcl)?
>
> Thank you for your help.
>

----------------------------------------------------------------------
Ray Ontko   rayo@ontko.com   Phone 1.765.935.4283   Fax 1.765.962.9788
Ray Ontko & Co.   Software Consulting Services   http://www.ontko.com/