HiveBrain v1.2.0
Get Started
← Back to all entries
gotchasqlMinor

SQL Server - What is the difference between BULKADMIN and ADMINISTER BULK OPERATIONS

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
theoperationswhatsqlandbulkbulkadmindifferencebetweenadminister

Problem

To grant user ability to run Bulk Insert T-SQL command, login/user needs to be granted:

  • BULKADMIN server role - or - ADMINISTER BULK OPERATIONS server-level permission



  • connect on target database



  • insert on target table



But what is the difference between BULKADMIN server role and ADMINISTER BULK OPERATIONS server-level permission ?

Solution

If we look at the SQL Server Permissions Poster (2017 edition):

It appears as though ADMINISTER BULK OPERATIONS covers bulkadmin in addition to OPENROWSET which allows access to external sources.

Context

StackExchange Database Administrators Q#266005, answer score: 3

Revisions (0)

No revisions yet.