Question

Error of Insufficient Privilege while spooling IFS report to excel

I
Rank
Userlevel 1
Badge +3

Please I am having this IFS error of insufficient privilege while spooling report to excel, and the select privileges on the table have been granted already. This spools correctly when a normal report is run, but fails when I choose Export to Excel

Error message: "Excel Plugin Error: ORA-06550: line 11, column 26: PL/SQL: ORA-01031: insufficient privileges"

 

 

2 replies

Charana Udugama
Rank
Userlevel 7
Badge +10

Hi @israelol,

Did you grant the SELECT privileges of the table/view to the user IFSSYS? If not use the below command to do so. 

 

GRANT SELECT ON <table or view name> to IFSSYS;

 

Best Regards,
Charana

https://lk.linkedin.com/in/charanau
I
Rank
Userlevel 1
Badge +3

I have granted privileges to IFSSYS, but it is still bringing same error.

Reply


Terms & ConditionsCookie settings