Impact of SQL Server Security on Query Results

In the previous chapters, you have learned different methods to query your data sources and create datasets that can be used to do further analytics on that data. Now you have been given a new assignment and have been asked to give your SQL query to a co-worker. One day, the co-worker comes to you and says that the SQL query that you gave them does not work. You test it out and it gives you the correct results. Why does this happen?

This chapter will start by explaining what SQL Server security is and how it can impact the result set of a query from one user to another. We will then discuss how you can verify what your security settings are for a database and will wrap up the chapter by discussing the steps that may need to be taken to modify SQL Server security for a user so that they can run an SQL query and get the correct results. This chapter will not provide the training to enable you to manage the security of a database; it will...