They use a single account to access SQL Server. Everyone logs in to the database with the same username. It's stored as part of the connection string or built dynamicly. (Commonly called application-specifc login)
The other way is for each user to have their own user name to SQL Server. This can be an Active Directory account or a SQL Server account. Typically, users are then placed in a group and the group is give access rather than each individual account.
>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.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer