services / Azure / Database top queries query text

The raw SQL statement text of the top queries executed against an Azure SQL database, retrieved by query ID via Query Performance Insight.

Query text frequently embeds literal values (filter predicates, INSERT/VALUES) and reveals schema, so it can leak both stored-data fragments and structure for a single database.


Microsoft.​Sql/​servers/​databases/​topQueries/​queryText/​action

Returns the literal SQL text of executed queries, which can leak sensitive literal values embedded in statements and reveal schema/table/column structure of the database.

Risks

Scope: HIGH

This privilege may grant access to sensitive data from a single organizational function, or allow interruption of a service supporting a single organizational function.

Links

  • https:​/​/​azure.​permissions.​cloud/​iam/​Microsoft.​Sql
  • https:​/​/​learn.​microsoft.​com/​en-​us/​azure/​role-​based-​access-​control/​resource-​provider-​operations
  • Contributed by P0 Security

    © 2023–present P0 Security and contributors to the IAM Privilege Catalog