ygalipeau

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

 

1682.Untitled.png

 

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

 

thanks

 

yannick

Outcomes