Post reply

Deny access to OPENQUERY

  • March 20, 2009 at 3:11 am

    #129907

    Hello,

    On SQL Server 2000, I have a couple of linked servers configured to connect using custom credentials. Is it possible to restrict a sql server login from using OPENQUERY, without altering those linked servers?

    Thanks in advance,

    Romulus C.

  • March 20, 2009 at 8:07 am

    #963532

    Please post SQL 2000 questions in the SQL 2000 forums in the future.

    It is not possible to restrict users from using openquery. As Books Online notes

    Permissions

    Any user can execute OPENQUERY. The permissions that are used to connect to the remote server are obtained from the settings defined for the linked server.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • March 20, 2009 at 8:36 am

    #963565

    Thanks, sorry for posting in the wrong area.

    I was hoping for a workaround.

    Thanks again.

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

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