gotchasqlMinor
SQL Server - What is the difference between BULKADMIN and ADMINISTER BULK OPERATIONS
Viewed 0 times
theoperationswhatsqlandbulkbulkadmindifferencebetweenadminister
Problem
To grant user ability to run
But what is the difference between
Bulk Insert T-SQL command, login/user needs to be granted:BULKADMINserver role - or -ADMINISTER BULK OPERATIONSserver-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
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.