Make Read Only Responsibility of Users in Oracle Apps

For a leading American client’s audit team required access to all the oracle applications responsibilities. The access was required to carry out the internal audit. They required read only access as they were auditing the system and not performing transactions or setup configurations.

Add Responsibility to a User in oracle apps

Syntax:

fnd_user_pkg.addresp(username => v_user_name

,resp_app => 'SYSADMIN'

,resp_key => 'SYSTEM_ADMINISTRATOR'

,security_group => 'STANDARD'

,description => 'Auto Assignment'

,start_date => SYSDATE - 10

,end_date => SYSDATE + 1000);

Script to Report System Privileges Granted to Users & Roles

Running this script will create a report of all the grants of roles to users and other roles.

REM LOCATION:   Backup Recovery\Generate Recreation Scripts

REM FUNCTION:   SCRIPT FOR CAPTURING SYSTEM PRIVILEGES GRANTED TO USERS AND ROLES

REM TESTED ON:  7.3.3.5, 8.0.4.1, 8.1.5, 8.1.7, 9.0.1, 10.2.0.3, 11.1.0.6

REM PLATFORM:   non-specific

REM REQUIRES:   dba_sys_privs