Skip to main content
Question

Error of Insufficient Privilege while spooling IFS report to excel

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"

 

 

    Charana Udugama
    Superhero (Employee)
    Forum|alt.badge.img+12

    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
    Dilhan Perera
    S
    B
    3 people like this
    • Dilhan Perera
      Dilhan Perera
    • S
      Savini Malalarathna
    • B
      bhhelk
    I
    Do Gooder (Partner)
    Forum|alt.badge.img+3
    • israelol
    • Do Gooder (Partner)
    • May 3, 2022

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

    Reply


    Terms & ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings