DB role to import a file

sam nick 286 Reputation points

I have a user with ddladmin, datareader and datawriter permission, in the azure sql db, but yet they are unable to import a an excel via ssms. What role or permission must be granted explicitly. I have tried searching but nothing short of an db_owner comes up.

Azure SQL Database
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Anurag Sharma 17,566 Reputation points

    Hi @sam nick , welcome to Microsoft Q&A forum.

    I think ddladmin role should be sufficient enough to import the excel. Could you please provide the screenshot of error message your are getting and which excel version you are using?