question

KeithBayen-2015 avatar image
0 Votes"
KeithBayen-2015 asked NavtejSaini-MSFT commented

Admin rights on free azure trial

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
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

NavtejSaini-MSFT avatar image
0 Votes"
NavtejSaini-MSFT answered NavtejSaini-MSFT commented

@KeithBayen-2015

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


· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@KeithBayen-2015 DO let us know if you need further help with this.

0 Votes 0 ·

How do I connect to the master?

0 Votes 0 ·

You can use the SSMS tool and select from the tool bar to select master DB.

80901-image.png


0 Votes 0 ·
image.png (18.7 KiB)