Admin rights on free azure trial

Keith Bayen 1 Reputation point
2021-03-17T18:36:17.377+00:00

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.

Azure SQL Database
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Navtej Singh Saini 4,226 Reputation points Microsoft Employee Moderator
    2021-03-18T22:30:59.283+00:00

    @Keith Bayen

    Can you please try running these commands:

    On Master:
    Create Login [username] with password ‘password’
    Create User [username]

    Database Level:
    Create User [username]
    ALTER ROLE db_owner add member [username]
    GRANT ADMINISTER DATABASE BULK OPERATIONS TO [username];
    GRANT INSERT TO [username];
    GRANT CONTROL TO [username];

    Once done let us know the result. Also do check this document for more info regarding this.

    Regards
    Navtej S


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.