Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 24 Oct 2001 @ 17:03:32 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Segregating Users in Business Objects
From:   Thomas F. Stanek


I don't recall exactly how BO works, (it's been a long time since I last used it), but if BO generates the SQL from a server and "normal SQL" is submitted from the user's client (i.e. queryman, etc.), you might be able to distinquish the query source by examining the LogonSource column in the DBC.EVENTLOG table (i.e. LOGONOFF). The column is normally populated with the IP address of the requestor for a network request. Therefore, the server IP address would be in LogonSource for BO queries while the client IP address would be in LogonSource for QueryMan queries. Of course, any requests from that server (BTEQ, etc.) would also have the same IP address.

BTW, for mainframe requests, LogonSource contains job information.

Let everyone know if this works for you or not.

Hope this helps.


Thomas F. Stanek
TFS Consulting

  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020