Post reply

Msg 7415,when I use Select with OpenRowSet

  • January 28, 2011 at 6:35 am

    #233569

    Hi all,

    I'm using Sql User sysadmin, no problem, but when I'm using no sysadmin I received the message 7415 (Ad hoc access to OLE DB provider 'Microsoft.Jet.OLEDB.4.0' has been denied. You must access this provider through a linked server).

    How must to do for no sysadmin execute this comand (Select * From OpenRowSet('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=X\XXX\XXX.xls' , [Sheet1$]).

    Thank´s

    Ian.

  • February 3, 2011 at 11:10 am

    #1282049

    One way would be to have this as a linked server another would be that if it is in storeprocedure and is not an ad-hoc useage for the select you can sign the store procedure with a user that has sysadmin and users that don't have sysadmin can execute and the procedure executes with the sign credential permissions of sysadmin.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply