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
Author
Message
Posted Friday, August 02, 2013 3:10 PM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Thursday, April 10, 2014 1:08 PM
Points: 721, Visits: 1,264
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
Post #1480624
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse