sqlserver安全加固

来源：互联网发布：北京威锐达知乎编辑：程序博客网时间：2024/05/22 17:33

sqlserver2012安装好以后必要的安全加固，不然很多DBA的信息普通账户登录后都可以读取到.

--use [master]--GO--DENY VIEW SERVER STATE TO [public]--GO--use [master]--GO--DENY VIEW ANY DATABASE TO [public]--GO/**********部分sqlcopy需要这个权限不能拿掉--use [master]--GO--DENY VIEW ANY DEFINITION TO [public]--GO*******/ ----限制用户登录后查看登录名--DENY SELECT on OBJECT::[sys].[server_principals] to [public]--go --use [master]--GO--DENY SELECT ON [INFORMATION_SCHEMA].[TABLES] TO [public]--GO--DENY SELECT ON [sys].[syslogins] TO [public]--GO--use [master]--GO--DENY SELECT ON [sys].[index_columns] TO [public]--GO--use [master]--GO--DENY select ON [sys].[indexes] TO [public]--GO--use [master]--GO--DENY SELECT ON [sys].[all_views] TO [public]--GO--use [master]--GO--DENY SELECT ON [sys].[objects] TO [public]--GO--use [master]--GO--DENY SELECT ON [sys].[columns] TO [public]--GO--use [master]--GO--DENY SELECT ON [INFORMATION_SCHEMA].[VIEWS] TO [public]--GO--use [master]--GO--DENY SELECT ON [sys].[filegroups] TO [public]--GO--use [master]--GO--DENY SELECT ON [INFORMATION_SCHEMA].[COLUMNS] TO [public]--GO--use [master]--GO--DENY SELECT ON [sys].[schemas] TO [public]--GO--use [master]--GO--DENY SELECT ON [sys].[databases] TO [public]--GO--use [master]--GO--DENY SELECT ON [sys].[all_columns] TO [public]--GO--use [master]--GO--DENY SELECT ON [sys].[procedures] TO [public]--GO--use [master]--GO--DENY SELECT ON [sys].[all_objects] TO [public]--GO--use [master]--GO--DENY SELECT ON [sys].[servers] TO [public]--GO

1 0