What is the SQL Server equivalent for Oracle Virtual Private Database?

Question

What is the SQL Server equivalent for Oracle Virtual Private Database (VPD)?

+6

security sql oracle sql-server owasp

McGovernTheory Jun 29 '09 at 13:55

source share

2 answers

Arnkrishn · Answer 1 · 2009-06-29T14:00:58+0000

For row-column and column-level security and other aspects such as fine-grained access control in SQL Server, you can check this http://technet.microsoft.com/en-us/library/cc966395.aspx

Dan · Answer 2 · 2011-07-31T23:44:18+0000

You can create VPDs in SQL Server using VIEW objects. SQL Server has a USER function that returns a database user similar to how Oracle does it.