Re: User setup problem.
From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 04/07/05
- Next message: Onkar Walavalkar: "Use of stored proc sp_GetMBCSCharLen"
- Previous message: pdxJaxon: "Re: Index Tuning Wizard (Crud?) or just me"
- In reply to: Valerie Hough: "User setup problem."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Wed, 06 Apr 2005 20:16:35 -0600
Add the users to a Windows domain group that is granted
login permissions for SQL Server. Then add this group to the
database users.
To add a new users, just add them to the group - they will
have access to SQL Server and the database through their
windows group role membership which has the permissions..
When an upgrade is run, add the windows group to the
database users of the new database.
-Sue
On Wed, 6 Apr 2005 13:35:36 -0400, "Valerie Hough"
<sales@pcTrans.com> wrote:
>Hi,
>I know very little about 2003 Server System Administration and even less
>about SQL Server security!
>
>One of our customers has 2003 Server running with several XP clients in a
>domain set up just for my company's application, which runs under .NET and
>accesses a SQL Server 2000 database (which is on the server).
>
>They would like to have a way of setting up new users in the domain (using
>an active directory group or something similar) such that each time a new
>user is added, his/her Windows user name can just be added to this group and
>this new user will have necessary permissions to access SQL Server.
>
>They would also like NOT to have to associate these permissions with a
>particular database, since my company does periodic releases, each of which
>uses a new database name. Is this possible?
>
>Is it possible to do this without giving each new user Administrator
>privilege?
>
>Ideally this could be set up once, and each time the client wants to add a
>new user, we (or they) can just copy a template or an existing user and
>paste it. The client does not have access to skilled technicians because of
>their location; someone set up their operation and they call people in only
>as needed - they are remotely enough located that there are few competent
>service providers within a short drive
>
>Thanks in advance for any information or pointers to articles that might
>help.
>
>Brian Hough
>
- Next message: Onkar Walavalkar: "Use of stored proc sp_GetMBCSCharLen"
- Previous message: pdxJaxon: "Re: Index Tuning Wizard (Crud?) or just me"
- In reply to: Valerie Hough: "User setup problem."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
