Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Read Only access on a specific table 1

Status
Not open for further replies.

AndrewWiggins99

Programmer
Jul 30, 2014
12
CA
We have a ticket system with a SQL Server backend. We want to grant a developer READ ONLY access to a specific table however we need to have additional security. We dont want the developer to have access to all the contents of that table. Is there a way to limit what type of data the user can access VIA backend?
 
Here's an idea...

You could create a view with just the columns you want the developer to have access to, and then grant the user readonly on the view.


-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom
 
and if a view does not allow you enough granularity you can give select permission at a column level from at least 2008 R2

Regards

Frederico Fonseca
SysSoft Integrated Ltd

FAQ219-2884
FAQ181-2886
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top