SQL Server气象资料数据库的安全管理

现在气象服务与人们生活、工作联系很紧密,气象资料数据的安全性变得非常重要。文中概述气象信息服务系统,对SQL Server气象资料数据库的安全机制进行了分析,介绍了身份验证和权限管理两个重要概念,通过Windows集成验证模式和混合验证模式两种模式来验证用户身份;通过划分角色来分配权限。最后通过一个管理扩展存储过程实例对SQL Server气象资料数据库的安全性进行了分析,从而达到限制他人权限来保护气象资料数据库的安全。

Security Management of SQL Server Meteorology Data Database

Now,meteorology service relate closely to people's life and work.It's very important to the security of meteorology data.This article summarizes service system of meteorology data,analyzes security mechanism of SQL Server Meteorology data database,introduces two important conceptions of authentication and permission.Authenticates users by two modes: Windows authentication and mixed authentication,and grant permissions by roles.Finally,from a case for management of extention procedure,analyzes the security of SQL Server meteorology data database,so that limit others permissions to protect the security of meteorology database.