SQL Server Performance Forum – Threads Archive

Security Access

Hi, Please provide you input on how can i configure security access in SQL server 2005 which is the best practice. I am currently having 60 to 70 user which will access SQL server 2005. Out of which some are developer and some are power user. Please provide me the best to achieve that. Thanks and Regards
Ravi K

http://www.microsoft.com/sql/technologies/security/default.mspx
http://www.databasejournal.com/features/mssql/article.php/3483931 Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Hi,
also refer below links :
http://vyaskn.tripod.com/sql_server_security_best_practices.htm http://sqlsecurity.com/FAQs/SQLSecurityChecklist/tabid/57/Default.aspx
Regards Hemantgiri S. Goswami
[email protected]
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami

Good article on
sql-server-performance
http://www.sql-server-performance.com/security_resource_kit_interview.asp —————————————-
http://dineshasanka.blogspot.com/

]]>