Is it possible to read/write into a SQL Server 2005 database, from a VB.NET application, using a user who does NOT have a sysadmin server role?
Asked
Active
Viewed 806 times
0
-
4Yes. Of course. What would be the point of a security system if everyone had to be sysadmin? – Damien_The_Unbeliever Sep 26 '12 at 10:26
-
@Damien_The_Unbeliever Well, it would be much easier to use for one thing ;) – RB. Sep 26 '12 at 10:36
1 Answers
0
To read from all tables in a database, there is a Database role called db_datareader. To insert/update/delete from all tables in a database, there is a Database role called db_datawriter.
The user will need to be mapped to a login at the Instance level, but no server roles will be required, especially not sysadmin.
Pete Carter
- 2,691
- 3
- 23
- 34