How do I give all logged in users CRUD privileges to a database?

  • 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.

    http://www.sqlservercentral.com/Forums/Topic1471731-324-1.aspx

    Kindest Regards, Rod Connect with me on LinkedIn.

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply