did you grant access to the nickname to user myuser

On May 8, 11:11 am, "Damir" <damirwil...@yahoo.com> wrote:
> Hello,
> I have a strange problem with federated access between two DB2 databases,
> both on AIX 5, both instances V9.1 (FP02).
>
> For the sake of this post, the two DB2 databases are named:
> 1. "live"
> 2. "archive"
>
> When I create the user mapping on the "live" database:
>
> db2 "create user mapping for myuser server my_archive_server options
> (remote_authid 'myuser', remote_password 'mypwd')"
>
> and then connect to the "live" database as user "myuser" and try to access
> any of the nicknames that point to the tables in the "archive" database, I
> get the following error:
>
> SQL0551N "The ODBC authid " does not have the privilege to perform
> operation "unknown " on object "unknown ". SQLSTATE=42501
>
> I gave proper (read) priviledges to the tables in the "archive" database, as
> well as to the nicknames in the "live" database.
> And yet I only managed to get rid of the above error by giving the user
> myuser direct DBADM priviledge on the "archive" database?!?
>
> Also (this is without user "myuser" having the DBADM priviledge on the
> "archive" db): trying to connect directly to the "archive" database as user
> "myuser" (using pwd "mypwd") works OK (connect priviledge given), and I can
> select from the tables in that database (select priviledges are given)
> without problems.
>
> So, why is the federated access not working with the above mentioned user
> mapping (unless given the DBADM priviledge), when the username and password
> are OK for connecting to the "archive" db?
>
> Any ideas would be much appreciated!
>
> Regards,
> Damir