IAL - Insufficient Privileges

I did simple IAL and deployed it..

When I try to select * from ifsinfo.Get_Total_Additional_Hours - I get the below error..

 

 

 

IFSINFO has access to all other IAL tables.. so that isn’t a problem here I guess.

 

Below is the IAL that was deployed..

 

 

 

Any idea what am I missing ?

 

Regards,

Rajesh.N

If you have a look at the instructions in the yellow section on your left hand side, you’ll note #5 mentions replacing ‘appowner’ i.e. ifsapp with &AO.. 

Try that and redeploy your IAL.

Hi Anmise,

I did change all ifsapp. to &AO..  but still I get the same error.

select emp_no, &AO..Time_Pers_Diary_Result_API.Get_Presence_Hours(company_id, emp_no, valid_from, valid_to) presence,
&AO..Time_Pers_Diary_Result_API.Get_Absence_Hours(company_id, emp_no, valid_from, valid_to) absence,
&AO..Work_Sched_Assign_API.Get_Sched_Hours_Db(company_id, emp_no, valid_from, valid_to) schedule
from &AO..AUTHORIZATION_EMP
 

I’m connected to the dB as IFSADMIN which should have access to that IAL object.. am I right ?

P.S. I’m executing the below query via PL/SQL where I’m connected to dB as IFSADMIN

SELECT * from IFSINFO.Get_Total_Additional_Hours

Hi Anmise,

 

I did change all ifsapp. to &AO..  but still I get the same error.

 

select emp_no, &AO..Time_Pers_Diary_Result_API.Get_Presence_Hours(company_id, emp_no, valid_from, valid_to) presence,
&AO..Time_Pers_Diary_Result_API.Get_Absence_Hours(company_id, emp_no, valid_from, valid_to) absence,
&AO..Work_Sched_Assign_API.Get_Sched_Hours_Db(company_id, emp_no, valid_from, valid_to) schedule
from &AO..AUTHORIZATION_EMP
 

 

 

You will need to grant the IAL to one of the permission sets you are granted. There’s a tab in the permission set screen called IAL.

 

 

Hi Anmise,

Thanks a lot.. I had to grant right to the new IAL object to my IAL permission set 

I can now access the table with the query.