How many users for a database application?

Hi,
lately i've been faced with a dilemma of whether i should choose to have one
database user to access the database from my app and have inbuilt user
management in the app itself or if i should choose to make a database user
for every user of the application, implementing minimal user management on
the app.
Which is best to choose? what is the best practice?
reagrds,Hi,
I recommend you to have seperate users in SQL server for each application
(provide prev. based on requirement), this will allow you to
have more security.
If you have the option of using Windows Authentication to connect to sql
server then you can set
the user and password policies for each user, this enables the highest
security level.
Note:
I will not recommend you to have application level users because of security
reasons.
Thanks
Hari
MCDBA
"Kazar Kunos" <kazar@.inbox.lv> wrote in message
news:e$92kfHiEHA.704@.TK2MSFTNGP09.phx.gbl...
> Hi,
> lately i've been faced with a dilemma of whether i should choose to have
one
> database user to access the database from my app and have inbuilt user
> management in the app itself or if i should choose to make a database user
> for every user of the application, implementing minimal user management on
> the app.
> Which is best to choose? what is the best practice?
> reagrds,
>
>