Oracle applications – List all the concurrent Jobs ran by user.

Posted by Jiltin     Tags: , , 9 January, 2009    1,325 views    (0) Comment

Here is the simple sql that gives you the all the concurrent Jobs ran by user. This is working code, verified in oracle 11i financial applications /***************** Author: Jay Substitute &user or pass as parameter ******************/ SELECT        fcr.REQUEST_ID,        FU.USER_NAME,        fcr.PHASE_CODE,        fcr.STATUS_CODE,        (fcr.ACTUAL_COMPLETION_DATE –   Read Full Article (Click here)...

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

Summary of Wordpress User Roles

Posted by Jiltin     Tags: , , 12 October, 2008    512 views    (0) Comment

Administrator - Somebody who has access to all the administration features Editor – Somebody who can publish posts, manage posts as well as manage other people’s posts, etc. Author - Somebody who can publish and manage their own posts Contributor – Somebody who can write and manage their posts but not publish posts Subscriber – Somebody who can read comments/comment/receive news letters, etc. Reference:http://codex.wordpress.org/Roles_and_Capabilities Following Read Full Article (Click here)...

Categories : MySQL, Web & Scripts, Web Mysql Tags : , ,

List Reponsibilities for an user

Posted by Jiltin     Tags: , , 12 March, 2008    1,524 views    (4) Comment

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 : Read Full Article (Click here)...

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