>>I have received an email from a customer IT on the subject of setting up user access to SQL Database for my VFP application.
>>The following line in the message, especially the user of 'granular' is new to me.
>>
>>With other apps such as this we have used one account to authenticate to the db if auditing is not granular
>>
>>Could anybody explain what you think it means? TIA.
>
>As far as the one account I assume that means that what they've done in the past is simply create one SQL Server account for an entire application - so your connection string to the SQL Server backend would always be the same username/password no matter what user is logged in. As for the "granular" comment I can't even come up with a good guess - other than perhaps they don't use English properly..ha
So my understanding of the "one account" and setting this account into the connection string is that they would use SQL Server authentication, as opposed to Windows Authentication, correct?
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
