Read Only access on a specific table 1

[AndrewWiggins99]

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?

 

[gmmastros]

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

 

[AndrewWiggins99]

That is an excellent idea... Let me give that a try... Stay tuned...

 

[fredericofonseca]

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

http://www.syssoft-int.com

FAQ219-2884
FAQ181-2886