Re: Multiple roles?

Yes, rights of several roles accumulate for a user, but db_ddladmin does not
grant BULK INSERT rights.

They need to be members of the bulkadmin server role in order to run BULK
INSERT in SS2000. In SS2005 you need ADMINISTER BULK OPERATIONS, plus
insert rights to the table and you may need ALTER TABLE permissions in some
cases.

See the Permissions subheading on the BULK INSERT command in either version
of Books Online.

RLF


"zz12" <IDontLikeSpam@xxxxxxxxxxx> wrote in message
news:uaHlkYSfHHA.444@xxxxxxxxxxxxxxxxxxxxxxx
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.



.

Relevant Pages

  • Re: Nimbus/BSkyB
    ... to pay a great deal more for the rights than they were actually worth. ... The bulk of the value is the TV rights *in* India; ... Nimbus aren't a broadcaster: therefore they have to get some Indian ...
    (rec.sport.cricket)
  • Bulk remove orphaned SID
    ... I would like to bulk remove an orphaned SID that was granted Send As rights ... to many accounts in our domain. ...
    (microsoft.public.windows.server.active_directory)
  • Re: Nimbus/BSkyB
    ... to pay a great deal more for the rights than they were actually worth. ... I'm not sure Mike. ... The bulk of the value is the TV rights *in* India; ...
    (rec.sport.cricket)