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?