Forum Discussion
Issues with Oracle Database Classification in Microsoft Purview
Hello,
I'm testing the registration of an Oracle on-prem database with Microsoft Purview. The scan is running successfully and ingesting metadata, but it is not identifying any classifications.
although this dataset is used with SQL Server and works properly, showing all the classifications, there is a section discussing this saying that If the user is not the owner of the table, the scan will run successfully and ingest metadata, but will not identify any classifications.
https://learn.microsoft.com/en-us/purview/register-scan-oracle-source#required-permissions-for-scan
But it's already done and the user have all the select roles and system roles.
Could anyone help i don't know where is the problem Thanks in advance
2 Replies
AS1522Microsoft
Hey GammaRamma I see you are still facing similar issue. Looks like an issue with Microsoft Purview not identifying classifications when scanning an Oracle on-prem database, despite the user having all the necessary roles and permissions.
So first of all please check permissions The user should have the SELECT_CATALOG_ROLE and the ability to create a session.
Review the logs for any additional error messages that might provide more context on the issue and please update,
We are having the same issue on an Oracle 12C instance where no classifications are being detected. We haven't tested with other versions of Oracle yet but would really appreciated some feedback on this.
