Re: Multiple roles?

Will look into it further. Thanks a bunch for both of your replies.
Totally appreciate it.

Take care.


"Erland Sommarskog" <esquel@xxxxxxxxxxxxx> wrote in message
news:Xns99116B91E56CYazorman@xxxxxxxxxxxx
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


.

Relevant Pages

  • 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)
  • Re: DBnull, Date and DataAdapter
    ... Assigning DBNull.Value to a date column should work ... > I have a strongly-type dataset with a datatable from SQL Server. ... > I read somewhere that you cannot update a datetime column in SQL Server ... > to a datetime column in a SQL Server table using a DataAdapter? ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Why cant variable assignment occur in a data retrieval operat
    ... stored procedure and then another select statement that uses those variables. ... portion of the select statement that you are not assigning to variables - but ... > how to construct a rowset when some of the rowset should be sent to the ... >> of me think of why SQL Server would prohibit this in a stored procedure. ...
    (microsoft.public.sqlserver.programming)
  • Multiple roles?
    ... 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, ... thought that when assigning a user multiple roles the role with the most ...
    (microsoft.public.sqlserver.security)
  • Re: Ping an IP address on a Local Network
    ... assign all of our IP address in house, and when we are assigning a new one, ... we wish to verify that it is not already in use. ... ping a certian IP, and tell me if it is in use or not. ... to use SQL Server - have a stored procedure which does the actual pinging, ...
    (microsoft.public.dotnet.framework.aspnet)