CAJ | 학술논문

存放在计算机中大量信息的安全问题以及敏感信息的防窃取、防篡改问题已经越来越引起人们的关注。为了实现对数据库管理系统中数据安全的需求，文中对系统的用户口令、C／S之间的签名认证、SQLServer2005数据库加密、系统分配角色和用户权限几方面对数据库管理系统的安全问题进行研究，使用C#和T—SQL语言进行具体实现。实际应用表明，这些措施能够准确地实现数据的加密，阻止非法用户操作系统，保证系统安全，达到了设计要求。
존방재계산궤중대량신식적안전문제이급민감신식적방절취、방찬개문제이경월래월인기인문적관주。위료실현대수거고관리계통중수거안전적수구，문중대계통적용호구령、C／S지간적첨명인증、SQLServer2005수거고가밀、계통분배각색화용호권한궤방면대수거고관리계통적안전문제진행연구，사용C#화T—SQL어언진행구체실현。실제응용표명，저사조시능구준학지실현수거적가밀，조지비법용호조작계통，보증계통안전，체도료설계요구。
The secure problem of large quantities of data stored in the computer and the ant-theft and anti-tampering issue of sensitive data have been drawn increasing attention. In order to satisfy the requirement of data security of database management systems, this article studies the security of the database management system from the aspects including user password, signature verification between c/s, SQL Server 2005 database encryption, system distributing role and user authority. C# and T-SQL language are used to implement them. The experiment and application show that these methods accurately realize encryption of data and prevent unauthorized users to operate system and ensure the safe of the system, and achieve the design requirement.