?
Solved

Security aspect of views in SQL Server

Posted on 2011-03-25
2
Medium Priority
?
234 Views
Last Modified: 2012-06-21
Hi

I was reading an article on views. How they are useful and in what scenarios. My query is what is the security aspect of view. Is it safe and how can you justify it.


Regards
Karan  
0
Comment
Question by:KaranGupta
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 3

Assisted Solution

by:kumarnimavat
kumarnimavat earned 600 total points
ID: 35214414
0
 
LVL 28

Accepted Solution

by:
Ryan McCauley earned 1400 total points
ID: 35215163
Views can ensure that people have easy access to only the data that they have rights to see. For example, if you grant a person rights to see only 3 of a table's 5 columns, you can create a view so they can do a "select *" from the view and see what they're allowed to see. In the same way, I person is only allowed to see HOUR details for full-time employees, you could add a where clause to the view "where emptype='FT'" and they'd just see those people.

They still have access to the tables, but it just makes viewing what they have access to easier, as opposed to forgetting to filter their results and being greeted with an "access denied" message constantly.
0

Featured Post

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
By, Vadim Tkachenko. In this article we’ll look at ClickHouse on its one year anniversary.
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question