The following SQL2000 master database table to fixed only read cannot modify and

The following SQL2000 master database table to fixed only read cannot modify and delete the data

Started by Hale at November 22, 2016 - 7:18 AM

Do the permissions on the login account, such as the use of a account login, permission can only give specific user database

Posted by Ted at December 06, 2016 - 7:37 AM

How to set permissions can only read data from other can not operate

Posted by Hale at December 19, 2016 - 8:27 AM

No 2000 environment, you try my steps:
1,
2,
3,
4, Select no problem, when create will error

Posted by Ted at December 22, 2016 - 8:39 AM

I create a test account, and then refer to the Advancedwork permission, other authority does not give, and then use the test login, access to tables in master, but not create

Posted by Ted at January 02, 2017 - 8:46 AM

First of all, are not allowed to modify the system table,:

use master
go
sp_configure 'allow updates',0
go
reconfigure with override
go


Then, you have to limit the login account privileges, such as the above, only allowed to login other common database, the mapping to the master database on the hook removed.

Posted by Basil at January 04, 2017 - 8:49 AM

You can refer to this, this is the SQL settings in Server 2008, I hope useful for you.:

Set the login account only view the Microsoft SQL Server Management Studio left the tree permissions

Posted by Basil at January 14, 2017 - 9:40 AM