I was able to run OPENROWSET with a non-priv user, but I don't have access to the IBMDA400 provider, and this may be a restriction related to that provider. Is it set to allow inprocess?
Why can't you use a linked server?
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]