azure sql user permission

0
votes

I am trying to run following script to create credential for azure blob storage on azure Master database with database admin account, but its giving me an error 'User does not have permission to perform this action'. Script : ' USE master CREATE DATABASE SCOPED CREDENTIAL 'XYZ' WITH IDENTITY='SHARED ACCESS SIGNATURE', SECRET = 'shared access signature of blob storage'
GO ' enter image description here

Any idea? Thanks in advance

1
azure-sql-databaseazure-storage-blobs

1 Answers

1
votes

You should create the database scoped user on your user Database. There are restrictions on 'master' in Azure SQL Database, even for DBA.