Post reply

Can we restrict windows authentication login to only selected databases..?

  • March 10, 2009 at 8:50 am

    #201224

    Hi All,

    Can we restrict windows authentication login to only selected databases..? Is it possible..?

    Thanks.

  • March 10, 2009 at 9:03 am

    #956866

    Sure. Any login, windows or SQL will only have access to the databases it's granted access to. If you don't grant access to a database the person using the login won't be able to access it.

    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 10, 2009 at 9:11 am

    #956876

    Can you pls explain it in details...

    I usualy assign database rights to SQL login...

    How can I do the same with windows..?

  • March 10, 2009 at 9:19 am

    #956883

    swmsan (3/10/2009)

    How can I do the same with windows..?

    Exactly the same way you do with a SQL login.

    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

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

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