Share via

Azure sql database xevent blob storage network

sakuraime 2,351 Reputation points
2021-04-14T13:06:21.26+00:00

https://learn.microsoft.com/en-us/azure/azure-sql/database/xevent-code-event-file

CREATE
DATABASE SCOPED
CREDENTIAL
-- use '.blob.', and not '.queue.' or '.table.' etc.
-- TODO: Assign AzureStorageAccount name, and the associated Container name.
[https://gmstorageaccountxevent.blob.core.windows.net/gmcontainerxevent]
WITH
IDENTITY = 'SHARED ACCESS SIGNATURE', -- "SAS" token.
-- TODO: Paste in the long SasToken string here for Secret, but exclude any leading '?'.
SECRET = 'sv=2014-02-14&sr=c&si=gmpolicysastoken&sig=EjAqjo6Nu5xMLEZEkMkLbeF7TD9v1J8DNB2t8gOKTts%3D'
;
GO

[https://gmstorageaccountxevent.blob.core.windows.net/gmcontainerxevent] << So this blob storage need to allow all network
inorder to let Azure sql to write to blob ...

how to secure it ??

87833-image.png

Azure SQL Database
Azure Storage
Azure Storage

Globally unique resources that provide access to data management services and serve as the parent namespace for the services.

Your answer

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