List Reponsibilities for an user

Posted by Jiltin     12 March, 2008    1,045 views   

I often get this issue to find out list of responsibilities assigned to an user, mainly to review the SOX controls or to enable new responsibilities.
Lazy enough to go to System Administrator screen to query it. I always keep the TOAD open session and it is easy to grab the details using this sql.

————————————————————————-
—     Author : Jay Gopal
————————————————————————-
SELECT fu.user_name,frt.RESPONSIBILITY_NAME, fu.user_id,furg.responsibility_id
FROM
fnd_user_resp_groups furg,
FND_RESPONSIBILITY fr,
fnd_responsibility_tl frt,
fnd_user fu
WHERE fu.user_name =upper( ‘&username’)
AND   fu.user_id = furg.user_id
AND   furg.responsibility_id = fr.RESPONSIBILITY_ID
AND   frt.responsibility_id = fr.RESPONSIBILITY_ID
ORDER BY 1

Following Google Searches Lead To This Post: red hat oracle runInstaller DISPLAY

Post to Twitter  Post to Delicious  Post to Digg    Post to StumbleUpon

Categories : 11i Scripts, Oracle AOL Tags : , ,

Comments
June 3, 2009

Hi, good post. I have been wondering about this issue,so thanks for posting. I’ll definitely be coming back

Posted by Bill Brown jr
October 22, 2009

Hi, great post. Do you have support script,also for SOX purpose, in order to have all responsibilities and their functions per user ?

Posted by Edi
October 22, 2009

Edi,

I did work on SOX user, responsibilities and the functions. However, it has set of sqls and plsql functions and procedures. It is not a simple straight forward sql or plsql, but complex one. If you need specific requirement and scenario, I can share only the portion of it.

Posted by Jiltin
December 23, 2009

Its fantastic..

Thanks a lot for your post

Posted by Ravikumar
Leave a comment

(required)

(required)