This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(16, 71%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECS%3C/text%3E%3C/svg%3E)
Hello,
I created a SQL Server Database project and imported a SQL Database. However, when building the project, the error message SQL70596: Cannot determine securable object class from permission Administer Database Bulk Operations is displayed, as shown in the print below.
I connected to the database using the server's administrator user, that is, he has permission to execute the command. Does anyone know how to solve this problem?
Best regards,
Cristina
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(25.6, 10%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
@Cristina Santana Souza Our sincere apologies for the inconvenience you are having with Visual Studio.
Request you to kindly report this issue so that we can fix it in an upcoming release.
Hi @KalyanChanumolu-MSFT , I'll report this issue, thanks!
The issue was reported on the link below:
Please try to connect to the database using SQL Server Management Studio (SSMS) and try this:
GRANT ADMINISTER DATABASE BULK OPERATIONS TO [pipeline];
Maybe try to remove that permission from the script in Visual Studio and run it on the Azure SQL Database using SSMS.
The issue is not with the user you are connected using VS but with the pipeline login.
Hi @Alberto Morillo ,
Thanks for your reply. I had already run this command in SSMS with the admin user and the command was executed successfully. I wouldn't want to just run this command manually, that's why I created a project to replicate the database structure to another using dacpac.
It seems like a bug with Visual Studio, that is the reason I suggested the workaround using SSMS. Could you please try to update VS 2019 SSDT to the latest? Maybe that do the trick.
Hi @Alberto Morillo ,
I tried Visual Studio 2022 Preview and the error was the same, it really looks like a tool bug.
Yes. It is a bug.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(28.799999999999997, 92%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAP%3C/text%3E%3C/svg%3E)
The same in Az Data Studio 1.40
(the solution would be rewrite to ALTER SERVER ROLE [BULKADMIN] ADD MEMBER . . . but then will fail for the alter :) )
