AF Oledb Provider Security

Discussion created by ygalipeau on Jan 11, 2011
Latest reply on Jan 17, 2011 by spilon

good morning,


i am using the pi oledb enterprise to query AF element. i have a question regarding security. i have a test user (devtest) with no rights at all on AF. when executing the following query:


select * from ekhoaf.ekho.asset.element


where ekhoaf is a linked server, i have the following message (which is normal as devtest has no access) however maybe we should get an empty recordset instead of an error:


Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "PIOLEDBENT" for linked server "ekhoaf" reported an error. The provider reported an unexpected catastrophic failure.
Msg 7330, Level 16, State 2, Line 1
Cannot fetch a row from OLE DB provider "PIOLEDBENT" for linked server "ekhoaf".


if i give access to a specific af element (PM1) to my user like in the image attached




i still get the same error message when i execute the query. is there something additional that i need to do?