资源描述:
《从数据行入手保护sql server数据安全--》由会员上传分享,免费在线阅读,更多相关内容在学术论文-天天文库。
1、从数据行入手保护SQLServer数据安全>> 在当今企业环境中,保证数据安全不是可有可无的工作。频繁曝光的入侵和欺骗事件、萨班斯◆奥克斯利法案、HIPAA法案规定和爱国者法案等都要求我们能够做到,将正确数据提供给正确的用户,防止其它无权限的人访问。一般来说,行级安全(roent varchar(50) NOT NULL)CREATE TABLE [dbo].[Orders]([OrderID] [int] NOT NULL,[CustomerName] [varchar](20) NOT NULL,[OrderTotal] [money] NOT NULL,[Dep
2、artment] [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--insert departme
3、nts tableINSERTINTO [dbo].[Departments] ([Department],[ParentDepartment]) VALUES ('North America','')INSERT INTO [dbo].[Departments] ([Department],[ParentDepartment]) VALUES ('East','North America')INSERT INTO [dbo].[Departments] ([Department],[ParentDepar
4、tment]) VALUES ('Southeast','East')INSERT INTO [dbo].[Departments] ([Department],[ParentDepartment]) VALUES ('Northeast','East')INSERT INTO [dbo].[Departments] ([Department],[ParentDepartment]) VALUES ('erica')INSERT INTO [dbo].[Departments] ([Depa
5、rtment],[ParentDepartment]) VALUES ('Southents] ([Department],[ParentDepartment]) VALUES ('NortherName],[OrderTotal],[Department]) VALUES (1,'Harris','11.00','East')INSERT INTO [dbo].[Orders] ([OrderID],[CustomerName],[OrderTotal],[Department]) VALUES (2,&
6、#39;Corrigan','22.00','Southeast')INSERT INTO [dbo].[Orders] ([OrderID],[CustomerName],[OrderTotal],[Department]) VALUES (2,'Corrigan','22.00','Southeast')INSERT INTO [dbo].[Orders] ([OrderID],[CustomerName],[OrderTotal],[Department]) VALUES (3
7、,'BalderName],[OrderTotal],[Department]) VALUES (4,'PilloerName],[OrderTotal],[Department]) VALUES (5,'Carpenter','55.00','Northeast')INSERT INTO [dbo].[Orders] ([OrderID],[CustomerName],[OrderTotal],[Department]) VAL123下一页>>>>这篇文章来自..,。UES