Purview sql database scanning error - Error: (3860) Required role of 'ALTER ANY DATABASE EVENT SESSION' is required to enable lineage scans Inner Code:5519

Question

I m trying to scan azure sql db but getting the below error

Error: (3860) Required role of 'ALTER ANY DATABASE EVENT SESSION' is required to enable lineage scans Inner Code:5519

Note when I switch off Lineage extraction, I can connect ( see below) but cant connect when lineage is on ( see above)

Answer 1

Below is the command which grants the Alter

USE AdventureWorks2012;
GRANT CONTROL ON DATABASE::AdventureWorks2012 TO Sarah;
GO

Thanks , this fixed my issue

Answer 2

Hello @DataArtist

Thanks for the question and using MS Q&A paltform

This error message indicates that the user account that you are using to set up the scan in Microsoft Purview does not have the necessary permissions to enable lineage scans.

To resolve this issue, you will need to grant the 'ALTER ANY DATABASE EVENT SESSION' role to the user account that you are using to set up the scan.

Hope this helps.