Page 1 of 1

Have select privilage on table but bind fails

PostPosted: Wed Apr 22, 2015 9:54 pm
by raj_2015
Hi,

I am able to do 'select' on a table TESTDEV.RMTABLE but unable execute a BIND. The program performs only 'select' on the same table. I have successfully created SYNONYM too on this table

BIND PLAN(RMSCHEK) MEMBER( RMSCHEK, )
ON(CS) VALIDATE(BIND) ACQUIRE(USE) RELEASE(COMMIT)
DSNX200I : BIND SQL ERROR
USING FYJR29A AUTHORITY
PLAN=RMSCHEK
DBRM=RMSCHEK
STATEMENT=111
SQLCODE=-551
SQLSTATE=42501
TOKENS=FYJR29A.SELECT.TESTDEV.RMTABLE
CSECT NAME=DSNXOSC
RDS CODE=-100

please help to understand what is the issue behind

Raj

Re: Have select privilage on table but bind fails

PostPosted: Wed May 20, 2015 6:41 pm
by pranav283
Hi Raj,

As per my understanding of BIND, if you are to 'BIND' a DBRM then you need to have a special BIND privilege on your id as mere 'select' access won't be sufficient to bind.

Check with your MVS or operators team whether do have bind the necessary privileges.
Also, if you are to create a new package id, then I guess you should also have BINDADD and CREATEIN priveleges.

Also, please check whether do you have SYSADM/DBADM authority.