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

Extracting Data in Excel - Security Risk Expand / Collapse
Author
Message
Posted Tuesday, March 12, 2013 9:42 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, November 1, 2013 9:23 AM
Points: 5, Visits: 44
I'm the programmer / sql guy. Our Finance department uses Excel heavily. We have some spreadsheets that pull data from a database that have several schemas. I was going to grant DB access to their Windows AD accounts but was wondering if creating Application Roles might serve me better.

I like the idea of App Roles but how do you use them in Excel? I can't find anything that shows how you can. I'm assuming because of the whole sp_setapprole requirement.

Any suggestions?

Thanks,
Scott
Post #1429908
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse