Skip to main content

Database Schema

This section provides comprehensive database schema documentation for the Access Analyzer 12.0 data collectors. Each data collector stores discovered configuration, permissions, and audit data in normalized tables, with denormalized reporting views for analysis and presentation.

SQL Data Collector Schema​

The SQL Data Collector discovers, audits, and reports on SQL Server instances, databases, principals, permissions, audit events, and sensitive data across the enterprise. The schema documentation covers:

File System Access Analyzer DC Schema​

The File System Access Analyzer data collector audits Windows, NFS, and Azure Files file systems for permissions, ownership, content, activity, and sensitive-data classification across four sub-modules (SA_FSAA_, SA_FSAC_, SA_FSDLP_, SA_FSDFS_). The schema documentation covers:

  • Table Relationship Diagrams (ERD) — Visual ERDs showing table relationships across all four collector modules
  • Core Data Collection Tables — 47 normalized tables populated directly by data collectors, partitioned by host with full foreign key relationships
  • Views — 20 SQL views that join and denormalize data for reporting
  • Enumeration & Lookup Values — Reference for coded values including TrusteeType, ResourceType, GateType, and the six-bit rights bitmask
  • Functions & Stored Procedures — 29 UDFs and stored procedures covering path resolution, effective-access computation, group membership expansion, and DFS path lookup
  • Index Reference — Complete listing of database indexes across all FSAA DC tables
  • Foreign Key Reference — Complete listing of foreign key constraints and cascade behaviors