Re: Adding permissions to an AD user on a remote database
- From: Sue Hoegemeier <Sue_H@xxxxxxxxxxxxx>
- Date: Mon, 27 Feb 2006 20:38:00 -0700
I'm not sure what you mean by 400 workstations - if a login
needs access to databases and stored procedures, you would
set that at the server level in SQL Server and in whatever
databases.
Unless there is something in the application itself that has
to be coded which would be an application issue
If you are just trying to add the login and user to the
databases, you can script these using t-sql commands. See
books online topics for sp_grantlogin, sp_grantdbaccess,
sp_addrolemember.
-Sue
On Mon, 27 Feb 2006 13:11:27 -0800, Chad T
<ChadT@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
I was wondering if someone can point me in the right direction. I am looking
for a way to automate (in a script format) the addition of a user to a
database on a remote server. We have an application that requires that the
user have Owner permissions on 3 databases and 1 store procedure. Manually
connectiing to 400 workstations will be a huge pain..
.
- Follow-Ups:
- Prev by Date: Re: SSPI handshake failed with error code 0x8009030c
- Next by Date: Re: Adding permissions to an AD user on a remote database
- Previous by thread: Re: SQL 2005 - Encryption of a distributed application database
- Next by thread: Re: Adding permissions to an AD user on a remote database
- Index(es):
Relevant Pages
|
|
