This discussion is archived
5 Replies Latest reply: Dec 7, 2012 1:18 PM by Aj05 RSS

Apex not reporting the Right App user

Aj05 Newbie
Currently Being Moderated
I am using Apex 4.0

In one of my pages it handles Insert or Update of data depending on a page item value- it updates or inserts.

In production the user is appearing as "ANONYMOUS"
where as in dev its appearing as "APEX_PUBLIC_USER"

So far in the update,insert I have tried

author=:App_user

author=NVL(V('APP_USER'),USER)

and also author = (select v('APP_USER') from dual)

I am seriously lost in this issue. Google hasn't resulted in anything useful either.

Any help would be greatly appreciated.
Thank you
  • 1. Re: Apex not reporting the Right App user
    Aj05 Newbie
    Currently Being Moderated
    Anyone??
  • 2. Re: Apex not reporting the Right App user
    714270 Pro
    Currently Being Moderated
    Are you using different authentication schemes in dev and production? This is how app_user is set:
    APP_USER is the current user running the application. Depending upon your authentication model, the value of the user is set differently. If the application is running using database authentication, then the value of the user is the same as the database pseudo column USER. If the application uses an authentication scheme that requires the user to authenticate, the value of APP_USER is set by the authentication scheme, usually to the user name used during authentication.

    Also, make sure that the comparison takes care of case; so it is safer to try (you can try lower or upper):
    lower(author) = lower(:app_user)
  • 3. Re: Apex not reporting the Right App user
    Patrick Wolf Employee ACE
    Currently Being Moderated
    Hi Aj05,

    I think you get different users on your production and dev system, because production is using EPG and dev is using Apache+mod_plsql or APEX Listener to connect your Browser with APEX running in the database. BTW, it would be better if your production system also uses Apache+mod_plsql or APEX Listener, because it's the better for performance.

    But about your problem why APP_USER returns one of the above values:

    -) Which authentication scheme are you using
    -) Is the affected page a public page (Edit Page -> Security -> Authentication = Page is public)?
    -) Are you prompted for a user/pwd before you go to this page?

    Regards
    Patrick
    -----------
    My Blog: http://www.inside-oracle-apex.com
    APEX Plug-Ins: http://apex.oracle.com/plugins
    Twitter: http://www.twitter.com/patrickwolf
  • 4. Re: Apex not reporting the Right App user
    ascheffer Expert
    Currently Being Moderated
    And:
    do you have a trigger on the table which sets the column author too?
  • 5. Re: Apex not reporting the Right App user
    Aj05 Newbie
    Currently Being Moderated
    Hey,
    That was exactly it. I was using the user variable so it was calling the DB user, instead of the app_user. Sorry for the late reply but i had finished the project and moved on to a different one.

    Thank you both

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points