Usermanagement with the sql server authentication RRS feed

  • Question




    i have an application that uses a SQL-Server with some databases on it. Now i want to use the ss authentication for some user-access management, therefore i have some questions:


    1) Can i use the ss authentication to provide some access limitations (examples: user A has just access to database A, user b has access to all databases on the server)


    2) is this recommended to use?


    3) if 1) and 2) is yes can i extend the access management that i can save some informations for the users? So that the client application can receive some access-informations and provide/reject the user access to some information.


    Thx for any help.

    Wednesday, November 19, 2008 10:42 AM


  • Hi,


    1. Yes, you can assign access rights for a SQL Server Login to specific databases only.


    2. Yes, only when necessary.


    3. You can assign permissions right down to specific columns within tables should you wish.





    Wednesday, November 19, 2008 11:07 AM