Skip to main content

What is the easiest method to create a full access Permission Set(similar to IFS_ALL in IEE) in Aurena? I am hoping there is easier way than granting access to all the Projections.

The goal is to create a permission set with access to everything in Aurena.

Thanks in advance!

I think you will need to grant all the projections anyway. But there is a one click button to do that. 

 

Also if they need reports and system privileges as well, grant them as well. 

 

 

This is a great tip! Thanks @Rusiru 

Hi @Srikanth,

 

Alternatively you could use the following scripts to achieve the same,

 

Grant all to IFS_ALL role,

BEGIN
   Database_SYS.Grant_All('IFS_ALL');
   COMMIT;
END;

 

Grant all projections to IFS_ALL role,

DECLARE
   CURSOR get IS
      SELECT t.projection_name projection_name
      FROM   fnd_projection_tab t
      ;
BEGIN
   FOR rec_ IN get LOOP
      Fnd_Projection_Grant_API.Grant_All(rec_.projection_name, 'IFS_ALL');
      COMMIT;
   END LOOP;
END;

 

Cheers !
Dhananjaya.

Terms & ConditionsCookie settings