>>>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.
>>
>>Further to what has already been said, the word "granular" means at a very detailed level -- as in grains of sand.
>
>Yes, I understand the meaning of the word, in plain English. I just was not sure how it is applied it to the SQL Server security description. Thank you.
Using a single account to access a database certainly makes configuration easy, but it makes auditing database use impossible or difficult at best.
I always recommend all users use their own account - especially if they have write access to the database.
____________________________________
Don't Tread on Me
Overthrow the federal government NOW!
____________________________________