-3

I have a small SQL server 2014 database that simply has just 3 tables and some information in them for a school group project and am wondering what the easiest way would be to have a group member be able to access the database rather then manually copying down all the information from each row and column. We wouldnt be changing any information in the database. Thanks.

ashgk
  • 31
  • 1
  • 3
  • Give them read access.... – S3S Nov 28 '16 at 20:40
  • 1
    Possible duplicate of [How do I grant read access for a user to a database in SQL Server?](http://stackoverflow.com/questions/6688880/how-do-i-grant-read-access-for-a-user-to-a-database-in-sql-server) – S3S Nov 28 '16 at 20:40

2 Answers2

0

I would create a database role. After you create the role add each person that needs access to that role then grant that role read access to each table. This way if a person in that group no longer needs access you can just remove them from the role and vise versa.

Wes Palmer
  • 880
  • 4
  • 15
0

Since this is a school project I am assuming that the SQL Server database is a local DB and not on a shared server. You could perform a backup and restore where you back up the database on your machine and send them the back up files and they can use them to perform a restore to create the database on wherever.

Anthony Ramirez
  • 36
  • 5