Re: Multiple roles?
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Thu, 12 Apr 2007 21:40:22 +0000 (UTC)
zz12 (IDontLikeSpam@xxxxxxxxxxx) writes:
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?
I would guess that rather all privs are unioned together, and DENY
takes precendence over GRANT.
In any case, BULK INSERT requires membership in the bulkadmin server role,
which you don't seemed to have assign to your users.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- Follow-Ups:
- Re: Multiple roles?
- From: zz12
- Re: Multiple roles?
- References:
- Multiple roles?
- From: zz12
- Multiple roles?
- Prev by Date: Re: Where did the connections come from?
- Next by Date: Re: GRANT CREATE DATABASE versus GRANT ALTER ANY LOGIN
- Previous by thread: Re: Multiple roles?
- Next by thread: Re: Multiple roles?
- Index(es):
Relevant Pages
|
|
