Focal Point
How to get DB user name and DB instance?

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/4081025222

April 09, 2007, 06:59 AM
Prasanna
How to get DB user name and DB instance?
All,
I need to get user name (who logged in to view report) and database instance of the report.I tried with GETUSER, but it gives the user who connected with the database.Any idea how to achieve this?Any in built function exist?
April 09, 2007, 07:55 AM
FrankDutch
Prasanna, try to use the " find" function here on this forum, you will find a lot of issues on username that might be helpful

Frank




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

April 09, 2007, 08:27 AM
Prasanna
Thanks frank.
Here is answer for one question.
-SET &USR = CNCTUSR('A8');


Regards
R.Prasanna