Share via

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

Mudassar A 506 Reputation points Microsoft Employee
2023-02-10T21:47:30.1033333+00:00

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

User's image

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

User's image

Microsoft Security | Microsoft Purview
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Mudassar A 506 Reputation points Microsoft Employee
    2023-02-14T05:45:08.81+00:00

    Below is the command which grants the Alter 

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

    Thanks , this fixed my issue

    Was this answer helpful?

    5 people found this answer helpful.
  2. PRADEEPCHEEKATLA 91,861 Reputation points
    2023-02-14T05:44:43.4566667+00:00

    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.

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments

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.