摘要
随着计算机技术及Internet技术的不断发展 ,越来越多的企业把烦琐的数据处理业务通过MIS系统完成 ,进而实现快速、科学的管理。然而 ,计算机内信息往往因为安全措施不当遭到恶性破坏 ,使数据被更改或窃取 ,因此 ,要求MIS系统具有较高的安全性。在实际开发应用软件过程中如何把数据库安全性与应用程序安全性合理的联系在一起非常困难。对MSSQLServer2 0 0 0用户安全性进行了分析。在此基础上 ,探讨了利用存储过程使用建立安全机制和利用应用程序角色建立安全机制两种方案。
With the development of technology of computer and Internet, more and more industries process the complex and tedious data through MIS system,in order to get high speed and more reasonable management. However, the information in computer can be damaged seriously in some cases, and the data also can be stolen if the security measure is poor. For this reason, the MIS system should be demanded to have higher safety. The user security of MIS system is one of important subjects in computer fields. It is very difficult to combine database security with application program security during developing application software. This paper discussed MSSQL Server2000 user security. With this understanding, both security schemes established by stored procedure and application role were discussed. The advantage, using application role to set up user security was explained.
出处
《抚顺石油学院学报》
2002年第4期44-58,共15页
Journal of Fushun Petroleum Institute