基于SQL Server的企业数据库系统安全机制设计

针对某煤矿机械制造企业数据库系统用户数量较多而影响数据库系统安全性能的问题,提出了一种基于SQL Server的数据库系统安全机制的设计方案;详细介绍了该安全机制中登录身份模式选择、应用程序验证、创建SQL Server组、设置数据库访问、设置与分配用户权限以及其他安全机制的设计;指出在设计该安全机制时,应首先创建全局组,通过SQL Server Users组获得服务器访问,通过具体数据库组获得数据库访问权限,然后根据用户访问需求创建数据库角色并对角色分配权限,最后全局组通过加入角色获得权限,从而可确保数据库系统的安全。实际应用验证了该安全机制的可行性和有效性。

Design of Security Mechanism of Enterprise Database System Based on SQL Server

In view of problem that database system of a Coal Mine Machinery Manufacturing Enterprise has many users and influences its safety performance,the paper proposed a design scheme of security mechanism of database system based on SQL Server.It introduced design of selection of login mode,application procedure confirmation,creation of SQL Server group,setting of database access,setting and assignment of user authority and other safety mechanisms in details.It indicated that when designing the security mechanism,it firstly should create global group,obtain server access through SQL Server Users group,obtain access authority of database through specific database group,and then should create database roles and assign authority to the roles according to access requirements of users,at last the global group obtains authority through adding the roles,so as to ensure safety of the database system.The actual application validates feasibility and effectiveness of the security mechanism.