title: PostgreSQL: Permission denied for large object
body: <p>When migrating from my development to staging environment, I encountered the following error during a hibernate sql call to the PostgreSQL database on the staging server.</p>
  
  <p>There is no error in the development environment. I am assuming it is a privileges issue on the satging db. However, I have never seen this error and I do not know where to look. Can anyone advise?</p>
  
  <blockquote>
    <p>Caused by: java.io.IOException: org.postgresql.util.PSQLException: ERROR: permission denied for large object 109138
        at org.postgresql.largeobject.BlobInputStream.read(BlobInputStream.java:123)
        at java.io.InputStream.read(InputStream.java:170)
        at sun.nio.cs.StreamDecoder.readBytes(StreamDecoder.java:284)
        at sun.nio.cs.StreamDecoder.implRead(StreamDecoder.java:326)
        at sun.nio.cs.StreamDecoder.read(StreamDecoder.java:178)
        at java.io.InputStreamReader.read(InputStreamReader.java:184)
        at org.hibernate.type.descriptor.java.DataHelper.extractString(DataHelper.java:71)</p>
  </blockquote>