How

• cw255

  SSC Enthusiast

  Points: 174

  More actions

  October 11, 2024 at 9:27 am

  #4467541

  Hi, wondering if someone can help me. We're trying to build an application that uses Azure SQL with a serverless DB instance. We're using a database scoped credential to ingest CSV data from azure blob - this all seems relatively straight forward and supported. Authentication is mixed, both the SQL super user and EntraID super user can run the stored procedure to bulk load the data but the scoped user we'd like to use cannot and gets

  You do not have permission to use the bulk load statement.

  It doesn't appear to be possible (or at lease we haven't find the right query) to grant bulkadmin at the server level either via a grant or by adding the user to bulkadmins - both give errors

  We're kind of lost, tried lots of thing, we have no dedicated DBA to help us proceed. Right now the user that can't run the stored procedure / bulk load has these permissions

  

  Is anyone able to help?

  Thanks

• Site Owners

  SSC Guru

  Points: 80330

  More actions

  October 12, 2024 at 10:10 am

  #4467913

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.