Menu

#34 Documentation for "utassert.eq_refc_query"

Open
nobody
None
Medium
[none]
2013-10-12
2013-10-02
Paul Walker
No

I have just answered two questions on Stackoverflow (here and here) where people have been getting ORA-01031: insufficient privileges errors when using utassert.eq_refc_query. I believe it's happening because utPLSQL uses EXECUTE IMMEDIATE to temporarily create a table. The user needs to have the CREATE TABLE privilege granted to them directly rather than via a role.

This should be made clear in the documentation.

Discussion

  • Paul Walker

    Paul Walker - 2013-10-12
    • Status: open --> Open
    • Priority: 5 --> Medium
     
  • Paul Walker

    Paul Walker - 2013-10-12
    • Fixed in version: --> [none]
     

Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.