azure-synapse-accesscontrol

import os from azure.identity import DefaultAzureCredential from azure.synapse.accesscontrol import AccessControlClient # Set your Synapse Workspace endpoint as an environment variable or replace directly # Example: 'https://<your-workspace-name>.dev.azuresynapse.net' synapse_workspace_endpoint = os.environ.get('SYNAPSE_WORKSPACE_ENDPOINT', 'https://your-synapse-workspace.dev.azuresynapse.net') # Authenticate using DefaultAzureCredential. This will try various methods # like environment variables, managed identity, and interactive browser login. credential = DefaultAzureCredential() # Create an AccessControlClient client = AccessControlClient(endpoint=synapse_workspace_endpoint, credential=credential) try: print("Listing role definitions...") role_definitions = client.list_role_definitions() for role in role_definitions: print(f"- {role.name} (ID: {role.id})") # Example: List role assignments (requires appropriate permissions) print("\nListing role assignments...") role_assignments = client.list_role_assignments() for assignment in role_assignments: print(f"- Role Assignment ID: {assignment.id}, Role ID: {assignment.role_definition_id}, Principal ID: {assignment.principal_id}") except Exception as e: print(f"An error occurred: {e}") print("Ensure you have the correct permissions (e.g., Synapse Administrator) and the SYNAPSE_WORKSPACE_ENDPOINT is correctly set.")