Skip to main content
Question

Error of Insufficient Privilege while spooling IFS report to excel

  • May 3, 2022
  • 2 replies
  • 218 views
I
Do Gooder (Partner)
Forum|alt.badge.img+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
    Superhero (Employee)
    Forum|alt.badge.img+12
    • Charana Udugama
    • Superhero (Employee)
    • 128 replies
    • May 3, 2022

    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

    Reach me via LinkedIn - https://www.linkedin.com/in/charanau
    I
    Do Gooder (Partner)
    Forum|alt.badge.img+3
    • israelol
    • Author
    • Do Gooder (Partner)
    • 3 replies
    • May 3, 2022

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


    Terms & ConditionsCookie settingsAccessibility statement