Clarity

  • 1.  DB Details for Proxy of a resource manager

    Posted Aug 04, 2016 06:47 AM

    Hi,

     

    I need database table details for Proxy of a resource manager. if a resource manager has assigned some person A as his proxy in his absence. Where this details is stored in database?



  • 2.  Re: DB Details for Proxy of a resource manager
    Best Answer

    Posted Aug 04, 2016 07:22 AM

    I hope you are referring to OOTB proxy functionality for action items. If so, you can try this,

    SELECT

         USE_PROXY,

         PROXY_USER_ID,

         START_DATE,

         END_DATE

    FROM

         CMN_SEC_USERS

    WHERE

          USER_NAME=<provide the user name who has set proxy>



  • 3.  Re: DB Details for Proxy of a resource manager

    Posted Aug 04, 2016 07:57 AM

    Thanks Sridhar... It helped me.