A data engineer manages multiple external tables linked to various data sources.

Create a single user role with full access to all external tables and assign it to all users.

Use Unity Catalog to manage access controls and permissions for each external table individually.

Set up Azure Blob Storage permissions at the container level, allowing access to all external tables.

Grant permissions on the Databricks workspace level, which will automatically apply to all external tables.