I signed up for a test account. When trying to bulk upload I got a permission error. When I tried to grant permissions I got an error saying I was not authorized to grant access.
Is there some default administrator account?
The query I got an error on was:
SELECT @JSON=BulkColumn FROM OPENROWSET (BULK '<filenmae>', SINGLE_CLOB) import SELECT INTO <dbname> ...
Error You do not have permission to use the bulk load statement
Then I tried to do grant permissions
GRANT ADMINISTER DATABASE BULK OPERATIONS TO [<username>];
Error: Cannot grant, deny, or revoke permissions to sa, dbo, entity owner, information_schema, sys, or yourself.
Then I created a new user and tried to grant permission to that user
GRANT ADMINISTER DATABASE BULK OPERATIONS TO [<newuser>];
Error: Grantor does not have GRANT permission.