How to get DB user name and DB instance?

Focal Point

This topic can be found at:
https://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