SQL Server - What is the difference between BULKADMIN and ADMINISTER BULK OPERATIONS 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 ?
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.