Schema Access for Azure sqlpool

Maitra-v, Anirban 141 Reputation points
2022-07-06T13:43:14.153+00:00

Hi,

  1. Let "ABC" is the admin of Azure sqlpool. We have a very secure schema which business does not want even sql admin to access. Is there any specific command we can use so that the admin can not see those secure schemas.
  2. In general ,is there any DMV which can the hold the Audit info for the users who are accessing the schemas and query they are using.
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,175 questions
{count} votes

Accepted answer
  1. Nandan Hegde 34,021 Reputation points MVP
    2022-07-06T15:46:50.303+00:00

    Hey,
    Unfortunately there is no way to restrict admin account. It would have access to everything including overriding dynamic data masking.

    As for the 2nd part, you can enable auditing to logs all logs and than analyse it :

    medium.com/@harioverhere/identifying-who-accessed-azure-sql-using-audit-logs-f2ef51de2df9


0 additional answers

Sort by: Most helpful

Your answer

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