Sorry for the delay in response to your question.Please try using the [] around the login GRANT ADMINISTER BULK OPERATIONS TO [firstname.lastname@abc.com]
Regards,
Oury
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hi All,
I am trying to grant BULK INSERT permission to myself on a database in Azure managed instance and my user login as firstname.lastname@abc.com is not working. I am using this script 'GRANT ADMINISTER BULK OPERATIONS TO firstname.lastname@abc.com.' The error messge says "Msg 102, Level 15, State 1, Line 1 Incorrect syntax near '.' "
Can anyone help please.
Sorry for the delay in response to your question.Please try using the [] around the login GRANT ADMINISTER BULK OPERATIONS TO [firstname.lastname@abc.com]
Regards,
Oury
In Azure SQL Database, INSERT and ADMINISTER DATABASE BULK OPERATIONS permissions are required.