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

Help
Bulrush
2014-05-09
2014-05-09
  • Bulrush
    Bulrush
    2014-05-09

    • Win 7

    • i-net Clear Reports 12.1 (Crystal Reports)

    • Postgres SQL 8.4

    • Java 1.6.0_27

    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 postgres sql username has read permissions only, do I need more
    permissions on the postgres sql end?

    Thanks.