Azure sql database xevent blob storage network

sakuraime 2,271 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 Accounts
Azure Storage Accounts
Globally unique resources that provide access to data management services and serve as the parent namespace for the services.
1,549 questions
{count} votes