1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Tables of Responsabilities

Discussion in 'System Administration & Application DBA' started by tomloera, Feb 14, 2011.

  1. tomloera

    tomloera Forum Expert

    Messages:
    167
    Likes Received:
    6
    Trophy Points:
    260
    Location:
    Monterrey Mexico
    Can help me?

    What are the tables in contain the responsabilities of the user profiles?

    I found the FND_USER but only have the user profile and the description but not the responabilities.

    Thanks of your help
    Regards
     
  2. Sadik

    Sadik Community Moderator Forum Guru

    Messages:
    1,906
    Likes Received:
    252
    Trophy Points:
    1,455
    Don't remember from the top of my head, but try view record history on the user screen. If that doesn's show anything, try

    Code (SQL):
    SELECT * FROM tab WHERE tname LIKE '%RESPON%'
    and see which tables it returns.

    I will take a look when I get to office.
     
  3. tomloera

    tomloera Forum Expert

    Messages:
    167
    Likes Received:
    6
    Trophy Points:
    260
    Location:
    Monterrey Mexico
    Sadik;

    Thanks of your help

    Regards