Solved

Aurena - Full access

  • 24 March 2021
  • 3 replies
  • 337 views

Userlevel 6
Badge +18

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!

icon

Best answer by Rusiru Dharmadasa 25 March 2021, 03:52

View original

This topic has been closed for comments

3 replies

Userlevel 6
Badge +15

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.

Userlevel 5
Badge +10

This is a great tip! Thanks @Rusiru 

Userlevel 7
Badge +19

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.