Disclaimer:Hey Guys, this post contains affiliate link to help our reader to buy best product\service for them. It helps us because we receive compensation for our time and expenses.

INTRODUCTION:

In this section, we will learn what permission are available that will help user to perform the bulk operation.

In Azure synapse analytics, user with fixed database role {db_owner} can perform anything on SQL pool placed on Azure workspace.

But to harden access security, only intended or permissible account get the {db_owner} role.

If any user or role need permission to perform the bulk operation below is the syntax.

GRANT ADMINISTER DATABASE BULK OPERATIONS TO [user\role]
;