Multiple roles?

From: "zz12" <IDontLikeSpam@xxxxxxxxxxx>
Date: Thu, 12 Apr 2007 10:15:22 -0700

Hello. I was wondering if someone could help me understand better about
assigning a user to multiple roles. I created a role for some developers
from another group to be able to to DTS over some data (select, insert,
delete, update) into our local tables from their sql server. I also
assigned them to the db_ddladmin role. They tried to DTS our new data and
looked like they were able to delete the data in our local tables but their
bulk insert command to insert the data wasn't successful. I read and
thought that when assigning a user multiple roles the role with the most
priveleges takes in effect?

Thanks in advance.

.

Follow-Ups:
- Re: Multiple roles?
  - From: Erland Sommarskog
- Re: Multiple roles?
  - From: Russell Fields

Prev by Date: Re: Where did the connections come from?
Next by Date: Re: Multiple roles?
Previous by thread: RE: Running into security issues when attempting to deploy a Report Mo
Next by thread: Re: Multiple roles?
Index(es):
- Date
- Thread

Relevant Pages

Re: Multiple roles?
... assigning a user to multiple roles. ... I read and thought that when assigning a user multiple ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
(microsoft.public.sqlserver.security)
Re: Multiple roles?
... assigning a user to multiple roles. ... developers from another group to be able to to DTS over some data ... I read and thought that when assigning a user multiple ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
(microsoft.public.sqlserver.security)