1 Reply Latest reply on Aug 26, 2013 8:59 AM by bluebyteDIT

    How can i check users rights??

    Faraz Shaykh

      How can i check users rights??

        • 1. Re: How can i check users rights??
          bluebyteDIT

          SELECT FRV.RESPONSIBILITY_NAME,

                 FUR.DESCRIPTION

            FROM FND_USER_RESP_GROUPS_DIRECT FUR,

                 FND_RESPONSIBILITY_VL       FRV

          WHERE 1 = 1

             AND FUR.RESPONSIBILITY_ID = FRV.RESPONSIBILITY_ID

             AND (FUR.END_DATE IS NULL OR FUR.END_DATE > SYSDATE)

             AND FRU.USER_ID = -- fnd_user.userid