Control rights

Hi,
I am looking for a better of administer login for our
users, all on microsoft environment.
Here is my sistuation:
Our backup procedure cause the database to override every
day. This procedure cannot be changed.
We currently have a scripts that run every night to
give 'datareader' right to each database.
We frequently have issue with the script fail and new user
need to add in manually which sometime cause error.
What is the best pratice for this senario?
culam"Culam" <anonymous@.discussions.microsoft.com> wrote in message
news:bcb701c3ece8$69b95fb0$a001280a@.phx.gbl...
> I am looking for a better of administer login for our
> users, all on microsoft environment.
> Here is my sistuation:
> Our backup procedure cause the database to override every
> day. This procedure cannot be changed.
> We currently have a scripts that run every night to
> give 'datareader' right to each database.
> We frequently have issue with the script fail and new user
> need to add in manually which sometime cause error.
> What is the best pratice for this senario?
I do not understand why you are running a script to add datareader to each
database...
Best practice would involve planning role based security by creating NT
Global groups, placing the global groups in local groups, granting login
permissions to SQL Server to the local groups and database permissions (as
required). Add (or remove) users to the global groups to give (or remove)
the security rights.
Steve