¿Cual es la diferencia entre BULKADMIN y ADMINISTER BULK OPERATIONS en Sql Server 2008 R2?

Question

Hola, necesito saber la diferencia entre BULKADMIN y ADMINISTER BULK OPERATIONS en Sql Server 208 R2, asi mismo ventajas y desventajas de ambas...

GRACIAS....

---

Freddy Encinas M.

Answer 1

ADMINISTER BULK OPERATIONS is a permission. You can grant the ADMINISTER BULK OPERATIONS permission to a login.
(GRANT ADMINISTER BULK OPERATIONS TO [domain\Freddy];)

BULKADMIN is a fixed server role that has the ADMINISTER BULK OPERATIONS permission. You can add a login to the BULKADMIN fixed server role.
(ALTER ROLE BULKADMIN ADD MEMBER [domain\Freddy]; or EXEC sp_addsrvrolemember [domain\Freddy], 'BULKADMIN';)

---

Rick Byham, Microsoft, SQL Server Books Online, Implies no warranty

Answer 2

I guess Freddy wanted to know the practical difference. That is, what happens if I add user to the bulkadmin role vs what happens if I grant him ADMINISTER BULK OPERATIONS?

I have not been able to notice any differences, but I have not made very close investigations.

---

Erland Sommarskog, SQL Server MVP, [e-mail]

Answer 3

Lo siento. I agree. There should be no difference.

---

Rick Byham, Microsoft, SQL Server Books Online, Implies no warranty

Answer 4

Buenos dias

Correcto, necesito saber la funcionalidad practica, de ambas. Y ver cual aplicar. Tambien ver cual implica menos riesgos a nivel de seguridad. Y si exiten ventajas entre ambos.

---

Freddy Encinas M.

Answer 5

Hi Mago

Reference :   

Bulkadmin vs ADMINISTER BULK OPERATIONS

BULKADMIN and security

Thanks

Saurabh Sinha

Answer 6

These two are functionally equivalent. The BULKADMIN role is part of the old permission system that was originally in the product. It is not very granular. The ADMINISTER BULK OPERATIONS permission is part of the new, more detailed permission system introduced in SQL Server 2005. In this case, they are the same. But in many situations, the new system is much better. So I recommend the new system whenever possible. Get to know it. Get to love it. See http://social.technet.microsoft.com/wiki/cfs-file.ashx/__key/communityserver-wikis-components-files/00-00-00-00-05/6327.Permissions_5F00_Poster_5F00_2012.pdf

Estos dos son funcionalmente equivalentes. El rol BULKADMIN participa en el sistema antiguo de permiso que estaba originalmente en el producto. No es muy granular. El permiso de operaciones a granel de administrar es parte del sistema de permiso nuevo, más introducido en SQL Server 2005. En este caso, son iguales. Pero en muchas situaciones, el nuevo sistema es mucho mejor. Por lo que recomiendo el nuevo sistema siempre que sea posible. Conocerla. Llegar a amarla. See http://social.technet.microsoft.com/wiki/cfs-file.ashx/__key/communityserver-wikis-components-files/00-00-00-00-05/6327.Permissions_5F00_Poster_5F00_2012.pdf

---

Rick Byham, Microsoft, SQL Server Books Online, Implies no warranty

Answer 7

Gracias Rick, me queda mas claro.

---

Freddy Encinas M.