Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

How do I give all logged in users CRUD privileges to a database? Expand / Collapse
Posted Friday, August 2, 2013 3:10 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, November 25, 2015 8:50 AM
Points: 841, Visits: 1,470
I've got a SQL Server 2008 R2 Express database that we're going to be using for an application we're re-writing. Currently we're using entity framework 4.2 to access it, but the connection string uses SSPI, so (as I understand it) that means it's using the currently logged in user. I thought I had that fixed, but apparently I don't. I want to make it so that all users properly logged into their Windows account will be able to do normal CRUD operations as well as run user defined stored procedures, in that SQL Express database. How do I accomplish that?

Never mind, I've asked this question already.

Kindest Regards,

Connect with me on LinkedIn.
Post #1480624
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse