Monday, February 25, 2013

Get Profile settings user level from Database

Query to retrieve profile seetings which are customized for user

select user_profile_option_name,
       decode(level_id,
              10001,
              'Site',
              10002,
              'Application',
              10003,
              'Responsibility',
              10004,
              'User',
              10005,
              'Server',
              'UnDef'),
       usr.user_Name,
       optval.*
  from fnd_profile_option_values optval
  join FND_PROFILE_OPTIONS_VL opt
    on opt.profile_option_id = optval.PROFILE_OPTION_ID
  join FND_USER usr
    on optval.level_value = usr.user_id
 where level_id = 10004
  

No comments: