Re: Getting Username, Password and Oracle instance name.

[Steve Hall <srh@CONVOY.COM>]

Yeah, you can use the metastrings.
%%OPRID%%       Operator's Signon ID
%%OPRPSWD%%     Operator's Password
%%ACCESSID%%    Database Access ID
%%ACCESSPSWD%%  Database Access Password
%%DBNAME%%      Database Name
%%INSTANCE%%    Process Instance


-----Original Message-----
From: Discussion of SQR, SQRIBE Technologies's database reporting
language [mailto:SQR-USERS@list.iex.net]On Behalf Of David A. Beck
Sent: Thursday, November 04, 1999 12:40 PM
To: Multiple recipients of list SQR-USERS
Subject: Re: Getting Username, Password and Oracle instance name.


Isn't it possible to pass the values in the Process Definition and then
display them within the SQR?  This will give you SYSADM access.





rayo@ONTKO.COM on 11/04/99 04:21:56 PM

Please respond to SQR-USERS@list.iex.net@Internet
To:     SQR-USERS@list.iex.net@Internet
cc:
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/




****************************************************************************
***
Note:          The information contained in this message may be privileged
and confidential and protected from disclosure.  If the reader of this
message is not the intended recipient, or an employee or agent responsible
for delivering this message to the intended recipient, you are hereby
notified that any dissemination, distribution or copying of this
communication is strictly prohibited. If you have received this
communication in error, please notify us immediately by replying to the
message and deleting it from your computer.  Thank you.  Ernst & Young LLP
****************************************************************************
***