<div>
Not what I was looking for, but your input is appreciated.
</div>


Not what I was looking for, but your input is appreciated.

<div>
<div class="content wysiwyg-content">
I have looked at a lot of diffent ideas, but does anyone know how to lock down an open query in SQL. An example of this would be, lets say I have a linked server &nbsp;that has open query. How could I make it so, that only certain users could access said query.<br />
<br />
Thanks!!
</div>
</div>


I have looked at a lot of diffent ideas, but does anyone know how to lock down an open query in SQL. An example of this would be, lets say I have a linked server  that has open query. How could I make it so, that only certain users could access said query.

Thanks!!

Open Query

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.