Call Procedure

[rick]

Hi

I m facing a weird problem when i m executing a procedure with
different IDs, The procedure has a select statement , and a codition.
when the conditon is met an update statement is ran to update the
selected records.

The procedure has been given privleges to a DBAgroup , all the user
IDs i m using belong that perticular group.

I can execute the procedure using some IDs in that group but not with
all of them.

Can someone tell me what i m missing here.

All the user IDs i m using have DBADM privileges.

Thanks in advance
RICK

[db2start@gmail.com]

Re: Call Procedure

Can you provide details of OS, db2level?

How has dbadm authority been granted in the database to a group that
all of these users are in oro to individual users?

Cheers,


On Jun 5, 5:14 am, rick <kantha...@gmai l.comwrote:

Hi
>
I m facing a weird problem when i m executing a procedure with
different IDs, The procedure has a select statement , and a codition.
when the conditon is met an update statement is ran to update the
selected records.
>
The procedure has been given privleges to a DBAgroup , all the user
IDs i m using belong that perticular group.
>
I can execute the procedure using some IDs in that group but not with
all of them.
>
Can someone tell me what i m missing here.
>
All the user IDs i m using have DBADM privileges.
>
Thanks in advance
RICK