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?

Possible duplicate of ERROR: permission denied for relation tablename on Postgres while trying a SELECT as a readonly user. You need to GRANT read privileges (USAGE, SELECT, etc) to the table and schema. — paulsm4
– paulsm4, Commented Dec 30, 2016 at 16:28
thanks for the response, however my table was created with the postgres user and the schema is public. it is a simple test to see how it works. the select stament is:EXEC SQL SELECT cliente, numseq INTO :R-CODCLI-TCTIT, :R-NUMSEQ-TCTIT FROM minha WHERE cliente = '12345678' AND numseq = '000001' END-EXEC. — orlando
– orlando, Commented Dec 30, 2016 at 17:35

Eugene Lisitsky · Accepted Answer · 2016-12-30 22:39:07Z

0

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

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

edited Dec 30, 2016 at 22:39

answered Dec 30, 2016 at 16:26

Eugene Lisitsky

13k6 gold badges42 silver badges63 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

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

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related