On Wed, Feb 24, 2010 at 10:48 AM, Alan Bourke <[email protected]> wrote: > > > On Wed, 24 Feb 2010 12:29 +0100, "Allen" <[email protected]> > wrote: >> I find MSSQL such a pain as the >> permissions side means it works sometimes and not another. > > Windows Authentication can be a pain - I tend to use the good old > a-fashioned way. ----------------------------
My access is from a server instead of a desktop app. So I choose to present creds in teh connection string that represent the rights my user needs. Read & Write & run SPs Read Only for all reporting needs. When I get into sensitive data that will need specific rights to table(s) that nobody else has. All of this is just text data in a web.config file and it is all encrypted. customer gets an encryption program so they can set new text when they change servers, database names, etc. -- Stephen Russell Sr. Production Systems Programmer CIMSgts 901.246-0159 cell _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
