+18What 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!
Best answer by Rusiru Dharmadasa
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.
+19I 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.
+15Hi
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
