1

I have my SQL Server running on a remote server. I want to delegate tasks to my team who would be accessing the server to execute the ASP.NET application and hence the SQL Server Database credentials are stored on the connection string. But I do not want members of my team to take a backup of the database (or catalogs). How would I group the users keeping my SQL server safe?

Roman Marusyk
  • 23,328
  • 24
  • 73
  • 116
Slick Guy
  • 69
  • 6
  • This question is better suited for [Database Administration](http://dba.stackexchange.com/) – Mp0int Jul 28 '15 at 09:18

2 Answers2

0

Define a role and assign permissions to the role. Then assign the role to the user.

Martinaut
  • 1,868
  • 1
  • 17
  • 27
0

You could make two different users on the DB. One with admin rights for yourself, and another for read-only tasks like the asp.net applications. (Rights that dont allow them to make backups)

Give the second user only the required rights, and put those details in the connectionstring.

Anubis77
  • 102
  • 1
  • 6