SQL-server Express manager and user level access to specific database RRS feed

  • Question

  • Can I implement user-level access to different databases in SQL server Experss manager.
    I am not sure but there is some certificate scheme in SQL server2005,can someone give any detail inforrmation for this

    Thursday, November 10, 2005 6:11 PM


  • Yes.  Logins are granted access to databases on an individual basis.  Even if a particular Windows Login has access because of Windows Group membership (supposing you've created a Login for a Windows Group), you can still deny database access to individual Windows Login. 

    Theres a bunch of information on this in Books Online.  The topics in "Security Considerations for Databases and Database Applications" (ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/5d43fefc-5aa4-43d7-aedb-7808659449c5.htm) are a good place to start.

    Saturday, November 12, 2005 1:35 AM