#181 "Failed to determine auto increment status: java.sql.SQLException: ERROR: permission denied for relation xyz"

N/A
open
nobody
None
5
2014-05-09
2014-05-09
Bulrush
No

Finally found an 8.0 JDBC driver that works and now I'm getting these errors.

08:33:23.051 WARNING: Table.initColumnAutoUpdate - Failed to determine auto increment status: java.sql.SQLException: ERROR: permission denied for relation dashboard
08:33:23.051 WARNING: Table.initColumnAutoUpdate - SQL: select * from public."dashboard" where 0 = 1
08:33:24.330 WARNING: Table.initColumnAutoUpdate - Failed to determine auto increment status: java.sql.SQLException: ERROR: permission denied for relation report_trialbalance_summary
08:33:24.330 WARNING: Table.initColumnAutoUpdate - SQL: select * from public."report_trialbalance_summary" where 0 = 1
08:33:24.829 WARNING: Table.initColumnAutoUpdate - Failed to determine auto increment status: java.sql.SQLException: ERROR: permission denied for relation syexpire
08:33:24.829 WARNING: Table.initColumnAutoUpdate - SQL: select * from public."syexpire" where 0 = 1
08:33:25.032 WARNING: Table.initColumnAutoUpdate - Failed to determine auto increment status: java.sql.SQLException: ERROR: permission denied for relation report_summarypricelistrevenue
08:33:25.032 WARNING: Table.initColumnAutoUpdate - SQL: select * from public."report_summarypricelistrevenue" where 0 = 1
08:33:27.356 WARNING: Table.initColumnAutoUpdate - Failed to determine auto increment status: java.sql.SQLException: ERROR: permission denied for relation license
08:33:27.356 WARNING: Table.initColumnAutoUpdate - SQL: select * from public."license" where 0 = 1
08:33:28.963 WARNING: Table.initColumnAutoUpdate - Failed to determine auto increment status: java.sql.SQLException: ERROR: permission denied for relation executionkey
08:33:28.963 WARNING: Table.initColumnAutoUpdate - SQL: select * from public."executionkey" where 0 = 1

My username has read access to the db, but does that username need more permissions?

Thank you.

Discussion

  • Bulrush
    Bulrush
    2014-05-09

    Can't seem to edit original post. More info:

    • Win 7
    • Postgres SQL 8.4, I do not have access to the db server command line
    • Java 1.6.0_27