资源描述：
《从数据行入手保护sqlserver数据安全》由会员上传分享，免费在线阅读，更多相关内容在学术论文-天天文库。
1、从数据行入手保护SQLServer数据安全>>教育资源库 在当今企业环境中，保证数据安全不是可有可无的工作。频繁曝光的入侵和欺骗事件、萨班斯◆奥克斯利法案、HIPAA法案规定和爱国者法案等都要求我们能够做到，将正确数据提供给正确的用户，防止其它无权限的人访问。一般来说，行级安全(roent varchar(50) NOT NULL)CREATE TABLE [dbo].[Orders]([OrderID] [int] NOT NULL,[CustomerName] [varchar](20) NOT NULL,[OrderTotal] [money] NO
2、T NULL,[Department] [varchar](50) NOT NULL) CREATE TABLE dbo.Departments(Department varchar(50) NOT NULL,ParentDepartment varchar(50))--end create table script--script to clear then populate example tables--clear tablesDelete from departmentsDelete from ordersDelete from useraccess
3、--insert departments tableINSERTINTO [dbo].[Departments] ([Department],[ParentDepartment]) VALUES ('North America','')INSERT INTO [dbo].[Departments] ([Department],[ParentDepartment]) VALUES ('East','North America')INSERT INTO [dbo].[Departments] ([D
4、epartment],[ParentDepartment]) VALUES ('Southeast','East')INSERT INTO [dbo].[Departments] ([Department],[ParentDepartment]) VALUES ('Northeast','East')INSERT INTO [dbo].[Departments] ([Department],[ParentDepartment]) VALUES ('erica')INSERT IN
5、TO [dbo].[Departments] ([Department],[ParentDepartment]) VALUES ('Southents] ([Department],[ParentDepartment]) VALUES ('NortherName],[OrderTotal],[Department]) VALUES (1,'Harris','11.00','East')INSERT INTO [dbo].[Orders] ([OrderID],[CustomerName],[Or
6、derTotal],[Department]) VALUES (2,'Corrigan','22.00','Southeast')INSERT INTO [dbo].[Orders] ([OrderID],[CustomerName],[OrderTotal],[Department]) VALUES (2,'Corrigan','22.00','Southeast')INSERT INTO [dbo].[Orders] ([OrderID],[CustomerN
7、ame],[OrderTotal],[Department]) VALUES (3,'BalderName],[OrderTotal],[Department]) VALUES (4,'PilloerName],[OrderTotal],[Department]) VALUES (5,'Carpenter','55.00','Northeast')INSERT INTO [dbo].[Orders] ([OrderID],[CustomerName],[OrderTotal],[Departme
8、nt]) VAL123下一页>>>>这篇文章来自..
