Aurena - Full access | IFS Community
Solved

Aurena - Full access

  • 24 March 2021
  • 3 replies
  • 238 views

Userlevel 6
Badge +16

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 7
Badge +15

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. 

 

 

Userlevel 5
Badge +10

This is a great tip! Thanks @Rusiru 

Userlevel 6
Badge +13

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.