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