大家好﹗下面SQL在管理員帳號可以通過﹐但在非管理員下報錯[
Msg 7415, Level 16, State 1, Line 1
Ad hoc access to OLE DB provider 'SQLNCLI' has been denied. You must access this provider through a linked server.]
SQL:
select t1.*
from
openrowset('SQLOLEDB','IP';'USER';'PWD','select top 1 * from partflm ')T1
請問要怎么設置?