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, applicatio...
| Main Author: | |
|---|---|
| Format: | Article |
| Language: | zho |
| Published: |
Editorial Department of Industry and Mine Automation
2012-10-01
|
| Series: | Gong-kuang zidonghua |
| Subjects: | |
| Online Access: | http://www.gkzdh.cn/article/id/8677 |
| _version_ | 1797868596833026048 |
|---|---|
| author | HE Ya-ru |
| author_facet | HE Ya-ru |
| author_sort | HE Ya-ru |
| collection | DOAJ |
| description | 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. |
| first_indexed | 2024-04-09T23:58:26Z |
| format | Article |
| id | doaj.art-dabfd817a5034e279fd4dc860b566e01 |
| institution | Directory Open Access Journal |
| issn | 1671-251X |
| language | zho |
| last_indexed | 2024-04-09T23:58:26Z |
| publishDate | 2012-10-01 |
| publisher | Editorial Department of Industry and Mine Automation |
| record_format | Article |
| series | Gong-kuang zidonghua |
| spelling | doaj.art-dabfd817a5034e279fd4dc860b566e012023-03-17T01:59:52ZzhoEditorial Department of Industry and Mine AutomationGong-kuang zidonghua1671-251X2012-10-0138102932Design of Security Mechanism of Enterprise Database System Based on SQL ServerHE Ya-ruIn 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.http://www.gkzdh.cn/article/id/8677database system, security mechanism, sql server, access authority, database role |
| spellingShingle | HE Ya-ru Design of Security Mechanism of Enterprise Database System Based on SQL Server Gong-kuang zidonghua database system, security mechanism, sql server, access authority, database role |
| title | Design of Security Mechanism of Enterprise Database System Based on SQL Server |
| title_full | Design of Security Mechanism of Enterprise Database System Based on SQL Server |
| title_fullStr | Design of Security Mechanism of Enterprise Database System Based on SQL Server |
| title_full_unstemmed | Design of Security Mechanism of Enterprise Database System Based on SQL Server |
| title_short | Design of Security Mechanism of Enterprise Database System Based on SQL Server |
| title_sort | design of security mechanism of enterprise database system based on sql server |
| topic | database system, security mechanism, sql server, access authority, database role |
| url | http://www.gkzdh.cn/article/id/8677 |
| work_keys_str_mv | AT heyaru designofsecuritymechanismofenterprisedatabasesystembasedonsqlserver |