2

whats the best way to grant access to a few users to a couple tables in a SQL Server 2005 database?

I know the literature pushes the use of views but what is the gain over granting read only access to the actual table?

at least with the table there will be less overhead in that the index and other restraints are already in place and managed at the table (a single point of maintenance). If I make views then won't i need to maintain them and create indexes on them... as well as this will be additional overhead for SQL itself?

bobs
  • 21,844
  • 12
  • 67
  • 78
kacalapy
  • 9,806
  • 20
  • 74
  • 119

1 Answers1

9
CREATE ROLE role_name
GRANT SELECT ON table_name TO role_name

Don't forget to add users to that role. Adding individual permissions is generally a bad practice.

Using views and giving permissions to the view is useful if you want to hide particular columns / name columns in different ways / otherwise filter the data.

ScottE
  • 21,530
  • 18
  • 94
  • 131