Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] How to get the Windows User ID without usinf MRE?
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] How to get the Windows User ID without usinf MRE?
 Login/Join
 
Member
posted
We run many reports outside the MRE environment. We have a need to identify who is running what report. Is there a method to get the windows ID so it can be added to the select statement? I tried the GETUSER but this just return SYSTEM. I've been scanning the knowledge base but no success.

Thanks for the help,
Jim

This message has been edited. Last edited by: Kerry,


WebFOCUS 7.6.7
Windows
Output: all
 
Posts: 3 | Registered: February 12, 2009Reply With QuoteReport This Post
Expert
posted Hide Post
Jim you want to research "IWA", integrated windows authentication, and the &REMOTE_USER variable. Its something you enable on your wintel server, and edit your site.wfs to pass to you.(i think its the site.wfs, i may be mis-remembering)

At summit 2k7 the then-security guy, Jim Thorstad, gave a talk/lab on windows authentication, and you can get that handout from ibi.




In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Reply With QuoteReport This Post
Platinum Member
posted Hide Post
The snippet of code below will give you the user id which the person connects to the WF reporting server with -- I think this will give you the user id you are trying to obtain.
 
-SET &UID = CNCTUSR('A8');


WF 7.7.05
HP-UX - Reporting Server, Windows 2008 - Client, MSSQL 2008, FOCUS Databases, Flat Files
HTML, Excel, PDF
 
Posts: 149 | Location: Dallas, TX | Registered: June 08, 2007Reply With QuoteReport This Post
<JG>
posted
Jim susannah is absolutely correct. What you have available to you in a windows server environment is totally dependant on the security mechanisms that you have enforced on
your HTTP server and or application server depending on whether you are using an HTTP/app server configuration i.e. Apache or IIS and tomcat or a standalone installation using an app server only, and also what on what security method you are using on the WebFocus server, i.e. OPSYS, DBMS, PTH or LDAP.

IWA only works if you are using IIS as part of your installation and only if you have Allow Anonymous disabled.

REMOTE_USER also only works if allow Anonymous is disabled.

As susannah says you need to export what ever variable you use REMOTE_USER or IBIC_user via site.wfs for it to be available as a variable in the WebFocus session.

All the information required can be found in the security documentation DN4500790.1208
which can be downloaded from IBs doc library.

Using GETUSER( and CNCTUSER( only work providing you have sorted out the HTTP/App server and the WebFocus server security.
 
Reply With QuoteReport This Post
Gold member
posted Hide Post
in the site.wfs and/or ibicommand.wfs you could add this in the file:

REMOTE_USER=&WF_REMOTE_USER
REMOTE_USER(PASS)


WF 7.6.10 /IIS 6/ JBoss Enterprise 4.3
Windows XP SP 2/Windows 2003 Server
MVS 7.3.3
 
Posts: 76 | Location: Hartford, CT | Registered: August 30, 2005Reply With QuoteReport This Post
<JG>
posted
quote:
ibicommand.wfs

Not for a long time. The only .wfs script file that should be modified by
anything other than the system is site.wfs, and that should be done via
the administration console otherwise it requires a restart of your WebFOCUS
server and your http and application servers.
 
Reply With QuoteReport This Post
Expert
posted Hide Post
john,
are you saying that edits to the site.wfs
via the console does NOT require a restart of anything?




In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Reply With QuoteReport This Post
Master
posted Hide Post
susannah, that is correct. If you edit the site.wfs thru the WebFOCUS Administrator Console (Configure, Custom Settings) when to save it the web application picks up the new settings without having to restart anything. But be careful as such if you put something wrong in there you could cause a problem and not be able to relogin to the console. Speaking from experiance. then you have to restart things after fixing the site.wfs file.




Scott

 
Posts: 864 | Registered: May 24, 2004Reply With QuoteReport This Post
<JG>
posted
TexasStingray has it spot on.

Any changes made via the WebFOCUS admin console are applied when you save and do not require a restart of anything.
Providing that values or in the case of Custom settings (site.wfs) code are entered correctly and are valid.

Something that is invalid will require a manual change to the .wfs script files and restart of everything
but that's the same if you make manual changes anyway.

The reason is because it does not make any changes to the web applications.

This is totally different from the Report Caster admin console which requires a restart of caster and
the application server every time (making sure that you redeploy the rcaster app) even if you do something as simple as change the password for the caster
database.

This message has been edited. Last edited by: <JG>,
 
Reply With QuoteReport This Post
Expert
posted Hide Post
it worked! thanx John, and Tex. my changes went in right away...didn't have to go find one o' them redhats to restart iplanet for us.




In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] How to get the Windows User ID without usinf MRE?

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.