有关SQL中架构问题的探讨

常用数据库软件(如:Microsoft SQL Server 2005)中的数据存储,在大多数分布式Web应用程序中均扮演着重要的角色。这种数据存储可以包含所有类型的数据,包括用户应用程序首选项、机密的人事记录与医疗记录、审核日志与安全日志,甚至还包括用户访问应用程序时所需的凭据。显而易见,在存储这类数据以及对其执行读/写操作时都需要保证它们的安全,以确保只有具备相应授权权限的用户才能对其进行访问。SQL Server 2005中新增的架构功能使对用户的权限管理更回方便。

The Exploration of SQL Schema Issues

The data of the daily database software(such as Microsoft SQL Server 2005) are stored,playing an important role in most dis-tributed Web application program.This kind of data stores the data that can include all types,including user application program select for the first time,secret personnel record with medical records,check the daily record and daily record of the security,necessary evidence while even including users visit the application program.Obviously,carry out,read/write operate,needing security to guarantee them to it in the data of storing,So as to ensure only by possessing the corresponding users who authorize the authority can it interview it.The new-ly-increased framework function enables and goes back even more to users' authority management it convenient in SQL Server 2005.