Re: Help:How do you trace in this application?

On 17.12.2007 21:44, emdproduction@xxxxxxxxxxx wrote:
By one user, I meant no matter who loged into the application from the
web interface, from database end, I only see one user name, if I
select username from v$session, I got several app_user, with different
sid, from the same machine, which is the application server machine,
and same program, which wex.exe, and the same username, which is
app_user.

How could I trace it for a particular user, if they all login with the
same credential?

In the worst case you simply have to trace all sessions of this user, make your "special" user execute the commands you are interested in and switch off tracing for all again. Then you only need to find the SQL in the trace files from this exercise. Granted you'll likely collect much more than you need but if you keep the time window small that might be feasible. All in all I haven't found a good way to collect properly scoped data in such a scenario. And the situation is even worse when there is a connection pool for DB connections...

Kind regards

robert
.

Relevant Pages

  • trace sql without session_id and serial#
    ... SQL trace is off. ... I just have osname and username. ... Session is not connected right now. ... I cann't restart database, because so many people are working on it. ...
    (comp.databases.oracle.server)
  • Re: unable to connect to sql db
    ... but I get the 'login failed for username' message. ... you're either looking at the wrong database or your trace filter is too restrictive. ... If you create a new trace with no filter, and still see nothing, then the server / database you're running the trace on isn't the same one as your web app is trying to connect to... ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Pathname to access and usernames in shortcut
    ... >> network drive (for maintenance reasons initially, ... >> using usernames but no passwords. ... change their passwords within the access database (they won't know how ... >> gets the current username from the system and then calls access (via the ...
    (microsoft.public.access.security)
  • Re: Getting NT User Login Names from Access 2000 or 2003
    ... time, i can recreate it in the blank database, per all your other thoughts. ... In the table setup and adding the bound SomeOtherField field to the ... >> form, plus binding the orig MyUserName field, defaulted to fOSUsername, to ... using the username field as ...
    (microsoft.public.access.formscoding)
  • Re: hashed password and UsernameTokenManager
    ... Sami ... > The reason for further hashing and salting the already hashed password is ... > you have the database. ... >>> to also use hashed password text to construct the username token... ...
    (microsoft.public.dotnet.framework.webservices.enhancements)
Loading