SQL Server Security

在SQL Server 2008中的安全分为 Server Principal 和 Database Principal 两级，Server Pricipal 可以通过select * from sys.server_principal 获得，Database Principal可以通过select * from sys.database_principal.

1.      create login LoginName from windows with default_database = [defaultDB]

2.      create login [LoginName] with password = ,default_database= [defaultDB], default_language=[us_english],check_policy =OFF

 

• SQL SERVER AGENT SECURITY
• SQL Server Security
• [SQL Server] Essential SQL Server security tools
• SQL Server 2000 Security - Part 2 (Authentication)
• SQL Server Security Distilled (2nd edition)
• Introduction To Role-Based Security In SQL Server Reporting Services
• SQL Server扫盲系列——安全性专题——SQL Server 2012 Security Cookbook
• member server security option
• IIS Web Server Security
• SQL Server 2016新特性：行级别安全控制（Row-Level Security----RLS）
• Windows Server 2003 Security Infrastructures
• Windows Server 2003 Security Cookbook
• Web Server Security Best Practices
• Nginx - Security/Server Side TLS
• Security of Azure SQL Database
• Windows Server 2003 Security Infrastructures: Core Security Features
• Internet Security and Acceleration (ISA) Server
• Windows Server 2003 Security Guide学习笔记
• 计算余数
• 各大型网站架构分析收集
• MBR的读取
• 自定义单元格绘制组件DataGridViewCellPainter
• eclipse技巧学习
• SQL Server Security
• 搜索引擎优化的7点注意要点
• 怀念在CSDN的这段时光
• C# 3.0语言详解之基本的语言增强1
• 解决TIME_WAIT过多问题
• 关于scanf 输入数据格式与格式化字符串不匹配的困惑
• Rails源代码分析（19）：ActionController::Caching(3) PageCache
• Ajax RSS 阅读器
• 服装ERP应用(17) ERP助服装供应链“抱团取暖”