Limitations of the SQL Server Connector

The following features are not supported by the SQL Server Connector

• Nested Roles – Roles within other roles (Database roles and Server roles)

• SQL Server Permission Covering . See

  https://docs.microsoft.com/en-us/sql/relational-databases/security/permissions-database-engine?view=sql-server-2017#chart-of-sql-server-permissions

• Contained Users - SQL Server Database Contained Users . See

  https://docs.microsoft.com/en-us/sql/relational-databases/security/contained-database-users-making-your-database-portable
  

• MS SQL Server for Azure
• The following SQL Server Resources
• XML Schema Collections
• Message Types
• Contracts
• Services
• Remote Service Bindings
• Routes
• Full-text catalog and stoplists
• Symmetric Key
• Asymmetric Key
• Certificate
• Endpoints
• Availability Groups
• Database scoped credential

File Access Manager features not supported by the SQL connector

• What If for local groups
• Access fulfillment
• Data Classification
• Effective Permissions are not calculated. The flag is always set to FALSE