Error in cobol program on linux selecting from table in postgresql database

Question

I am new in developing Cobol programs in Linux environment.

My problem is that I create a table in PostgreSql and I am trying to connect to that table. The connection was sucessful and the sqlcode = 0. But, when I try to make a selection i receive the sqlcode = -0000000007 and the message:

SQLERRMC: ERROR: permission denied for relation minha;

Minha is my table. My connection string is:

01 dsn pic x(300) value "Driver={PostgreSQL}; - "Server=127.0.0.1;Port=5432;Database=orlandodb; - "Uid=postgres;"

Can anyone suggest how I can query the table?

Answer 1

Check your credentials, does your user have access to the db and table?

You may do it in another application like PgAdmin or alike.