在 SQL Server 2008 中实现行级安全 [英] Implementing Row Level Security in SQL Server 2008

问题描述

在 SQL Server 2008 中是否有内置功能或方法来模拟 Oracle 中的 RLS(行级安全性)?

Is there a built-in feature, or way to simulate RLS(Row Level Security) in SQL Server 2008 as found in Oracle?

推荐答案

此 MS 白皮书概述了如何执行此操作.http://technet.microsoft.com/en-us/library/cc966395.aspx

This MS whitepaper outlines how to do it. http://technet.microsoft.com/en-us/library/cc966395.aspx

您从表中获取权限，然后创建一系列安全表和角色，允许您验证用户的每个级别.在对用户设置安全检查后，您可以使用视图过滤用户可以通过安全级别和用户登录查询的内容.然后您在视图上插入、更新、删除而不是触发器以将操作重定向到表.

You take the permissions away from the table, then create a series of security tables and roles that allow you to validate each level for the user. After you setup your security checking on the user, you use a view to filter what the user can query via the security levels and the user's login. Then you have insert, update, delete instead of triggers on the view to redirect the action to the table.

这篇关于在 SQL Server 2008 中实现行级安全的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！