Security

 Securing ESS Jobs

• When a custom ESS job is created a Function Privilege with same name will be created implicitly
• Create a Custom JOB role and add the new custom ess privilege that is created
• Add the custom job role to USER
• Submit Retrieve Latest LDAP Changes job 

BIP Security

• Analytics -> Browse Catalog
• BIP Template -> More -> Permissions -> add -> Add user
• Following user will have following permissions. To modify More -> Permissions and change
  
• BI Administrator
• BI Author
• BI Consumer
• System Administrator(User)

 

----select /*3-25921486741*/
Distinct bu_id,
bu.BU_NAME,
u.username,
role.ROLE_NAME,
role.START_DATE_ACTIVE,
role.END_DATE_ACTIVE,
role.ACTIVE_FLAG
from fusion.hz_parties h,
fusion.per_users u,
fusion.per_all_people_f f,
fusion.FUN_ALL_BUSINESS_UNITS_V bu,
fusion.FUN_USER_ROLE_DATA_ASGNMNTS role
where 1=1
and h.user_guid = u.user_guid
and u.person_id = f.person_id
and sysdate between f.effective_start_date and f.effective_end_date
and role.org_id = bu.bu_id
and u.USER_GUID = role.USER_GUID
and u.username='WH6066'
and role.ACTIVE_FLAG='Y'
and bu_id=300000031108373

 select *
from fusion.FUN_USER_ROLE_DATA_ASGNMNTS role, fusion.per_users u
where  u.USER_GUID = role.USER_GUID ;

---- 

fnd_grants

--