SQL Server Performance Forum – Threads Archive
MS SQL server 2K security settings
I am using MS SQL server 2K. I want that my clients can update the database(which is true by default) but they cannot delete my database(which is true by default).<br />So can nebody help me out.[<img src=’/community/emoticons/emotion-11.gif’ alt=’8)’ />]hi,<br />what you can do is dont give them administrative / db owner privillage and please refer :<br /> <br /><a href=’http://www.sql-server-performance.com/vk_sql_security.asp’ target=’_blank’ title=’http://www.sql-server-performance.com/vk_sql_security.asp'<a target="_blank" href=http://www.sql-server-performance.com/vk_sql_security.asp>http://www.sql-server-performance.com/vk_sql_security.asp</a> </a> <br /><br /><a href=’www.sqlsecurity.com’ target=’_blank’ title=’www.sqlsecurity.com’>www.sqlsecurity.com</a><br /><br />and user will not able to drop database while application / ne user is using it. <br /> <br /><br />[<img src=’/community/emoticons/emotion-1.gif’ alt=’
‘ />]<br />Regards.<br /><br />Hemantgiri S. Goswami<br />[email protected]<br />"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri Goswami<br />
You can grant DB_DATAWRITER fixed database role permission to the logins and in addition to what was referred above. Refer to books online about fixed database roles.
Please post thread in relevant forums only.
Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
]]>