443.Chapter3

Lesson 1: Assessing database security needs for biz
1. What is a security policy
(1) A security policy is a document or set of documents containing rules that define the security framework of an organization, which provides high-level courses of action and guiding principals
(2) Benefits of a security policy
 It ensures that the security measures are enforced in a consistent manner throughout the organization
 It serves as reminder of management’s commitment to information security
 It can help reduce legal liability
 It serves to define the security responsibilities of each employee, along with the nature of a security violation
 It serves as a detailed set of rules from which to create simplified instructions or checklists of security practices.
2. Customizing a security policy
(1) Gather requirements
 Interview biz owners and company management
 Review regulatory requirements: SOX, HIPAA.
 Gather security variations: different user with different security privileges.
 Simplify biz security needs: simplify your list of stated biz security requirements
(2) Evaluate requirements
 Consider the various possible ways to meet the requirements, choose the way which are  not only meeting the security requirements but also without overwhelming your organization’s administrative resources.
 Evaluate the risk associated with security requirements
(3) Choose policies and exceptions
 Keep exceptions to a minimum
 Consider the ramifications of security exceptions
 Document security exceptions
3. Protecting SQL Server form network attacks
(1) Virus and worm attacks
 Deploy antivirus software on the database server and update the virus definition frequently.
 Apply the latest service packs and security packs for both SQL Server 2005 and Windows.
 Use database mail with caution. Allow only select users or groups to use this feature.
 Never expose your database server directly to the Internet: firewall + allowed port
 Require strong passwords for all user and service account.
(2) Denial of Service attacks (DoS): A DoS attack is a coordinate flood of service requests that attempts to overwhelm a server’s resources and cause it either to crash or to provide unacceptable performance to all other requests.
To spot a DoS attack, you need to recognize its symptoms, which typically include the following:
 A sudden and unexpected spike in logins
 Many connections originating from a common address or set of addresses
 A drop in SQL Server performance
The guideline to mitigate the damage of a DoS attack and prevent repeat attacks:
 Restart the SQL Service
 Restart the OS
 Block the IP address of the attacker
 Change the name or IP address of the server
(3) SQL Injection attacks
 Validate application input
 Do not use dynamic T-SQL
 Do not run service though highly privileged accounts
Lesson 2: Overview of SQL Server security
1. Security principals
(1) Security principals in SQL Server 2005 are entities such as users, logins, groups and roles that can request the use of database, server, or schema resources, which exist at three levels
(2) Window level: windows domain logins, local logins, and groups
(3) SQL Server level: include SQL Server logins and server roles
 SQL Server logins are generally reserved for users outside of the company; All SQL Server have the built-in sa login ID and password and might also have NETWORK SERVICE and SYSTEM logins
 Server roles provide administrative capabilities to role members, which are
Role Name Role description
bulkadmin Designed for domain accounts that need to perform bulk inserts into database
dbcreator Designed for users who need to create, modify, drop, and restore database
diskadmin Designed for users who need to manage disk files
processadmin Designed for user who want to control SQL Server processes
Securityadmin Designed for users who need to manage logins, create database permissions, and read error logs.
serveradmin Designed for users who need to set server-wide configuration options and shut down the server
setupadmin Designed for users who need to manage linked servers and control startup procedures
Sysadmin Designed for users who need complete control over SQL Server and installed database. Members of this role can perform any activity in SQL Server.
(4) Database level: include database users, application roles, and database roles.
• Database users are entities that are associated with Windows or SQL Server logins and that are assigned a configured set of permission and privilege to specific objects in the database. The default, or built-in, users include guest, dbo, INFORMATION_SCHEMA, and sys
Role Name Role description
guest Enable anyone with a valid SQL Server login to access the database
dbo Database owner, which is granted all permissions and privileges on the database
INFORMATION_SCHEMA Used by system internally to reference views of metadata in a database.
sys 
• Application roles enable user to create password-protected roles for specific applications.
• Database roles, it can be used to assign permissions at the database level. SELECT, INSERT, UPDATE and DELETE, which are the folloing:
Role Name Role description
public The default role assigned to all database users
db_accessadmin Add or remove logins in a database
db_backupoperator  Back up a database
db_datareader View data in a database. Can select all data from user tables
db_datawriter Add or modify any data in any user table in the database
db_ddladmin Perform tasks related to the data definition language for SQL Server. Members of this role can issue any DDL statement except GRANT, REVOKE, or DENY
db_denydataeader Designed to restrict access to data in a database by login. Cannot read any data
db_denydatewriter Restrict modifications permission in a database by login.
db_owner Complete control over all aspects of the database
db_securityadmin Manage permissions, object ownership, and roles
(5) What are SQL Server Securables?
Securables are entities within SQL Server to which you can assign permissions. The three top-level securables are server, database, and schema.
Securables scope Description
Server Server instance, databases, endpoints, logins, and server roles
Database Application roles, database roles, schemas, and users
Schema  Functions, procedures, tables, and views
(6) Verifying permission and privileges of security principals
function Description
IS_SRVROLEMEMBER Return 1 if the current login is a member of the specified fixed server role
HAS_PERMS_BY_NAME Evaluates the effective permission of the current user on a securable.
2. SQL Server 2005 authentication modes
(1) Windows authentication mode. Windows authentication mode leverages existing Windows user and group accounts for SQL Server
(2) SQL Server and Windows authentication mode
(3) Impact of authentication modes on service uptime: there must be one DC for Windows authentication
3. Integrating SQL Server into a Windows domain infrastructure
(1) What is a windows domain: A windows domain is a Windows network with a centralized authentication and security system
(2) What is active directory: : Active Directory is the directory service that has provided the basic structure and features of Windows domains since Windows 2000, which include domains, OUs, and forests.
(3) Active directory structures
4. Active directory authentication and SQL Server
(1) Kerberos(Windows 2000 or later), NTLM(NT or Windows 98)
(2) Service Principal Names for Kerberos.
 A service principal name (SPN) is the name by which a client uniquely identifies an instance of a service.
 When you configure SQL Server to run under the local system account, this SPN is automatically created. However, if you configure SQL Server to run under a service account, you should create the SPN manually. To configure an SPN for SQL Server, use the SETSPN utility available on the Windows Server 2003 CD.
 When you configure a domain account for use as a service account with SQL Server, be sure enable the account is trusted for delegation option in the properties of the user account.
5. Authentication guidelines for high-availability solutions
(1) Clustering service accounts security
 The account used to start SQL Server in the cluster must be a domain account.
 You should not change the passwords for any of the SQL Server service accounts when a failover cluster node is disabled.
 If the service account for SQL Server is not an administrator account in the cluster, the administrative share cannot be deleted on any node of the cluster.
 On Windows Server 2003-based clusters, you can use Kerberos authentication against SQL Server virtual servers
(2) Replication security
 Run each replication agent under a different Windows account, and use Windows authentication for all replication for all agent connections
 Add a local Windows account, which is not a domain account, for each agent on the appropriate nodes. You should use the same user name and password on each node.
 Ensure that an agent runs under the same account on each computer
 If you change the password for an account used by a replication agent, you need to execute the stored procedure sp_changereplicationserverpasswords to change the passwords on all replication servers.
(3) Mirroring endpoints and service accounts
 If the server instance uses the same domain user account for Database Mirroring sessions with Windows authentication, the correct logins exist automatically, and you do not need to create a login. However, if the server instances use different user accounts, you must create a login on each instance for the startup service account of each of the other instances.
 If the server instances are not in trusted domains, or is SQL server is running as a local service, Windows authentication is unavailable. You must configure the mirroring endpoint of each instance with its own locally created certificate.
(4) Security of log shipping
 You can select either Windows authentication or SQL authentication by the primary and secondary servers to connect to the monitoring server and update the monitoring tables
 For a backup job to succeed, you need to configure the SQL Server service account on primary server instance and the proxy account of the backup job to have read/write permissions to the backup directory
 For a copy job to be successful, you need to configure the proxy account of the copy job to have read permissions to the backup directory and write permission to the copy directory
 For a restore join to e successful, you need to configure the SQL Server service account on the secondary server instance and the proxy account of the restore job to have read/write permissions to the copy directory.
6. Practice: create a windows group for SQL Managers in AD
(1) Create account
(2) Create group 
(3) Adding administrative privileges
 
 

转载于:https://www.cnblogs.com/yang_sy/archive/2009/04/16/1437384.html

ubuntu22.04 安装部署 openclaw 阅读详情

相关推荐

论文解读——YOLOv11(目标检测)

YOLOv11提供了多种型号和功能,以满足不同应用场景的需求。对象检测对象检测是YOLOv11的基本功能之一。在训练时,YOLOv11能够检测图像中的对象,并输出对象的边界框和类别信息。这一功能在自动驾驶、智能安防等领域具有广泛应用。图像分割图像分割是YOLOv11的另一个重要功能。与对象检测不同,图像分割不仅检测对象的边界框,还能够对图像中的对象进行像素级别的分割。这使得YOLOv11在医疗影像分析、工业制造等领域具有更高的应用价值。姿态检测姿态检测是YOLOv11的一个独特功能。

qq_38220914的博客 4465

sqlserver2008远程连接不了

这两天要把以前连接sqlserver2000的程序搬到sqlserver2008下,遇到的一系列问题: 1.原来的连接字符串不行了 strSQL.Format("%s","PROVIDER=SQLOLEDB;SERVER=.;DATABASE=studentinfo;UID=

抬头做人低头做事 8260

基于PLC的立体车库控制系统设计

本文介绍了基于西门子S7-1511-1PN PLC和KTP700 Basic PN HMI的立体堆垛式停车场自动化控制系统。系统通过PLC逻辑控制滑台运动,配合传感器实现车辆存取自动化,包含初始化、入库、出库和安全保护程序。程序采用模块化设计,分为安全互锁、动画显示、模式切换等六个功能模块,运用边沿触发、定时器和多级联锁确保安全。HMI界面提供模式切换、车位选择、状态显示和手动控制功能。该系统具有模块化、安全性和可扩展性特点,可应用于多车位立体停车场场景。

sxs3030787796的博客 1266

Service Unit Test 报告 “not a domain class” 的问题

Service Unit Test 不能调用 GORM save() 等方法的问题原因。

杨波的专栏 513

最佳解决Maven同一依赖多版本共存问题,重复依赖(同一个jar包,多个版本)-maven-shade-plugin

公司的历史项目在导出功能上引用的是poi-3.12版本,后续再做word模板导出功能时用到了poi-3.15版本,升级完后发现项目的很多导出功能都瘫痪了。用旧版本,新功能无法使用;用新版本,旧功能瘫痪,且整改的工作量比较大。使用maven-shade-plugin,将某个版本的依赖名称进行修改,重新引入即可。

S_White_Island的博客 1万+

AOA(Angle of Arrival,到达角)定位算法及其误差分析的原理和MATLAB仿真_aoa定位算法

如图所示,有基站 S 1 ( x 1 , y 1 , z 1 ) , S 2 ( x 2 , y 2 , z 2 ) S_1(x_1,y_1,z_1),S_2(x_2,y_2,z_2) S1​(x1​,y1​,z1​),S2​(x2​,y2​,z2​),目标 T ( x , y , z ) T(x,y,z) T(x,y,z)。2+(z_1-z_2)^2} step1:两基站间的距离L=(x1−x2)2+(y1​−y2​)2+(z1​−z2​)2。

2401_87555613的博客 1485

443 Chapter9.Database Mirroring

Database MirroringLesson 1: Overview of Database Mirroring1.Database Mirroring Roles(1)sample(2)sample2.Principal Role(1)Sample(2)sample3.Mirror Role4.Witness Server5.Database Mirroring...

aoding8407的博客 174

31、摩擦学中的材料选择

本博文深入探讨了摩擦学应用中材料选择的重要性,分析了材料的机械、物理和化学属性对摩擦学性能的影响。同时介绍了材料匹配原则、处理方法及表面涂层技术,以优化耐磨性和抗腐蚀性。通过实际案例和评估方法,为读者提供了系统化的材料选择流程和决策依据。

juice的博客 249

443 Chapter6.Designing Database Security

Designing Database SecurityLesson 1: Designing Instance-level Security1.Configuring Service Account(1)In SQL Server 2005, when selecting the service account for SQL server instance, you should...

aoding8407的博客 214

07RK3568 I2S主模式 FPGA

RK3568与fpga通过i2s0连接,fpga连接音频芯片ES8388,RK为i2s主模式。调试时发现可正常采集来自fpga的数据。不可发送数据至fpga。由于i2s后连接fpga这里用了Rockchip的dummy-codec,一个虚拟的编解码器。

qq_39451352的博客 304

2024年ERP管理系统职业技能大赛软件测试赛项-测试报告

【说明本次测试的最终测试结果总结、测试过程中遇到的重要问题以及如何解决、被测系统的质量结论、个人的收获以及团队的得失等】【说明编写本测试报告的目的和实际读者】【说明本次测试实际人员安排及主要职责】【说明本次测试使用的测试用例设计方法】【说明本次测试使用的测试方法】【针对本次测试进行Bug汇总】【针对本次测试进行用例汇总】【说明本项目的背景情况】【说明本次测试的实际。

Code is fun. 792

443 CHapter5.Designing SQL Server Endpoints

Designing SQL Server EndpointsLesson 1: Overview of EndpointEndpoints control the capability to connect to an instance of SQL Server as well as dictating the communications methods that are acce...

aoding8407的博客 169

Temporal Noise Reduction(TNR)时序去噪技术解析:原理、平台实践与工程调优路径

随着高画质夜景拍照和高清视频拍摄需求的持续增长,图像传感器在低照度环境下输出信号的噪声问题日益突出。相比空间域降噪(SNR),时序去噪(Temporal Noise Reduction, TNR)利用帧间信息进行融合处理,具备更高的信噪比提升效率及更强的边缘保护能力,已成为移动影像ISP链路中的核心环节。本文系统剖析TNR的算法原理、平台实现机制与工程调试路径,并基于实际开发案例分析其在不同场景下的效果差异及调优方法,为工程师提供从理论到实操的完整路径参考。

努力分享一些人工智能、计算机视觉、影像等相关的知识干货! 3209

443 Chapter4.Designing Database Server Security Policies

Designing Database Server Security PoliciesLesson 1: Enforcing SQL Server Security through Group Policy1.What is Group Policy(1)Group policy is a framework that administrators use to control t...

aoding8407的博客 204

IMSL CNL 7.0.0 (x86-64)Crack

IMSL CNL 7.0.0 (x86-64)Crack intel的算法库破解文件,这是C++版本的破解文件

pscad IEEE标准系统搭建说明

pscad IEEE标准系统搭建说明,包含典型的IEEE 9节点、14节点、30节点、39节点和118节点系统。内含标准测试系统的原始数据和潮流结果。

CHAPTER 3 Zabbix & Grafana

zabbix & grafana

u010230019的博客 454

VC中sqlite的使用

在VC中对sqlite的使用,实现数据库大批数据的快速插入,读取数据库中的数据在ListCtrl中显示

443 Chapter7.Planning for High Availability in the Enterprise

Planning for High Availability in the EnterpriseLesson 1: Assessing Database Availability Requirements1.Calculating Availability(1) A = (F – ( MR + R )) / FA: AvailabilityF: Mean time betw...

aoding8407的博客 189

精雕软件(JDpaint) 5.5 绿色版

精雕软件(JDpaint) 5.5 绿色版精雕软件(JDpaint) 5.5 绿色版精雕软件(JDpaint) 5.5 绿色版

443.Chapter2 布署与合并多个数据库实例

第二章 部署与合并多个数据库实例I. Deploying multiple instances1.设计数据库实例。当满足下列情况时,应安装多个数据库实例。多个互相独立的sysadmin组数据库服务器需要为不同的组织提供数据库对不同的数据库实施不同的升级或者更新途径隔离相同的SQL Server登录名合并多个数据库服务器到单个数据库服务器2.规划数据库实例。下...

aoding8407的博客 179

chapter01作业

1、 请用命令查出ifconfig命令程序的绝对路径 [root@localhost chen]# which ifconfig /usr/sbin/ifconfig 2、请用命令展示以下命令哪些是内部命令,哪些是外部命令?(cd \ pwd \ ls \ ifconfig \ du) [root@localhost chen]# type cd cd 是 shell 内嵌(由...

weixin_30375247的博客 153

【计网】—— chapter 05 传输层

文章目录5.1 传输层功能1. TCP/IP协议集2. 传输层的两个协议3. 传输层协议和应用层协议之间的关系4. 应用层协议和服务之间的关系5. 传输层功能6. 传输层协议和网络层协议的主要区别7. 传输层端口5.2 传输层协议UDP和TCP5.2.1 UDP1. UDP特点2. UDP报文段格式3. UDP检验和5.2.2 TCP1. TCP特点2. TCP面向字节流的过程3. TCP的连接4...

S_123789的博客 897

计算机网络——chapter1_( http+web)

http & https 的区别: http 未加密 明文 不需要证书 块 端口 80 https = http +ssl 加密传输 身份认证 建立安全通道 需要 ca 证书 端口:443 从输入url到浏览器显示页面发生了什么 - 石海莹 - 博客园 从输入url到浏览器显示页面发生了什么 - 石海莹 - 博客园 从输入url到浏览器显示页面发生了什么 - 石海莹 - 博客园 从输入url到浏览器显示页面发生了什么 - 石海莹 - 博客园 从输入url到浏览器显示页面发生了什么

qq_23183809的博客 218
上一篇: 443.Chapter2 布署与合并多个数据库实例
下一篇: [Reference]SQL Server tempdb optimization tips
aoding8407
博客等级 码龄11年 2粉丝 0原创
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符  | 博主筛选后可见
 
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付:10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值