Have select privilage on table but bind fails



IBM's flagship relational database management system

Have select privilage on table but bind fails

Postby raj_2015 » Wed Apr 22, 2015 9:54 pm

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
raj_2015
 
Posts: 1
Joined: Wed Apr 22, 2015 9:36 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Have select privilage on table but bind fails

Postby pranav283 » Wed May 20, 2015 6:41 pm

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.
pranav283
 
Posts: 47
Joined: Sat Aug 30, 2014 3:52 pm
Has thanked: 2 times
Been thanked: 0 time


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post