Post reply

Disable Server Properties?

  • March 12, 2008 at 4:06 am

    #204229

    IS there a way of disabling the viewing of the Server properties in Management Studio, I have a user who requires access to a Db for SELECT statements but i would rather tham not be able to right click on the Server name and view the properties.

    Thanks

  • March 12, 2008 at 8:09 am

    #788568

    Normally, you cannot unless you disable the guest account.

  • March 12, 2008 at 12:58 pm

    #788750

    Andrew Collins (3/12/2008)

    IS there a way of disabling the viewing of the Server properties in Management Studio, I have a user who requires access to a Db for SELECT statements but i would rather tham not be able to right click on the Server name and view the properties.

    Thanks

    I haven't tried it, but how about DENY VIEW DEFINTIION on the database and then GRANT VIEW DEFINITION on the schemas?

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.     [/font]    [font="Verdana"] "Performance is our middle name."[/font]

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

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