Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Serviceconnector-passwordless Don't change the entra admin if I am already in a group assigned to the entra admin #27920

Closed
shaunpearsondev opened this issue Nov 24, 2023 · 6 comments
Assignees
Labels
app-service-transfer Auto-Assign Auto assign by bot bug This issue requires a change to an existing behavior in the product in order to be resolved. customer-reported Issues that are reported by GitHub users external to the Azure organization. Service Attention This issue is responsible by Azure service team. Service Connector az webapp/functionapp/springapp/containerapp connection Web Apps az webapp

Comments

@shaunpearsondev
Copy link

Describe the bug

When running

az webapp connection create sql

My specific user is always assigned to the entra admin for the resource targeted although I already have permissions to perform all the steps due to being in the group assigned

Related command

az webapp connection create sql

Errors

NA

Issue script & Debug output

Setting current user as database server AAD admin: user=xxx object id=yyy

Expected behavior

As I already have permissions the AAD/Entra admin shouldn't need to be changed

Environment Summary

azure-cli 2.54.0

core 2.54.0
telemetry 1.1.0

Extensions:
ai-examples 0.2.5
ml 2.21.1
serviceconnector-passwordless 0.3.12
ssh 2.0.2

Dependencies:
msal 1.24.0b2
azure-mgmt-resource 23.1.0b2

Python location '/usr/bin/python3.9'
Extensions directory '/home/xxx/.azure/cliextensions'
Extensions system directory '/usr/lib/python3.9/site-packages/azure-cli-extensions'

Python (Linux) 3.9.14 (main, Oct 12 2023, 19:48:32)
[GCC 11.2.0]

Legal docs and information: aka.ms/AzureCliLegal

Your CLI is up-to-date.

Additional context

No response

@shaunpearsondev shaunpearsondev added the bug This issue requires a change to an existing behavior in the product in order to be resolved. label Nov 24, 2023
@microsoft-github-policy-service microsoft-github-policy-service bot added customer-reported Issues that are reported by GitHub users external to the Azure organization. Web Apps az webapp Service Attention This issue is responsible by Azure service team. Auto-Assign Auto assign by bot Service Connector az webapp/functionapp/springapp/containerapp connection labels Nov 24, 2023
@yonzhan
Copy link
Collaborator

yonzhan commented Nov 24, 2023

Thank you for opening this issue, we will look into it.

Copy link
Contributor

Thanks for the feedback! We are routing this to the appropriate team for follow-up. cc @AzureAppServiceCLI, @antcp.

@yonzhan yonzhan removed the AAD label Nov 25, 2023
@houk-ms
Copy link
Contributor

houk-ms commented Nov 27, 2023

@xfz11 please take a look.

Copy link
Contributor

Thanks for the feedback! We are routing this to the appropriate team for follow-up. cc @AzureAppServiceCLI, @antcp.

@xfz11
Copy link
Member

xfz11 commented Dec 13, 2023

Hi @shaunpearsondev , thanks for your feedback. Please update the CLI extension to 0.3.13 with az extension add --name serviceconnector-passwordless --upgrade. It will ask for user confirmation before updating Microsoft Entra admin of SQL server.

@houk-ms
Copy link
Contributor

houk-ms commented Dec 13, 2023

hi @shaunpearsondev, may have a try and free feel to reopen the issue if there're more questions.

@houk-ms houk-ms closed this as completed Dec 13, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
app-service-transfer Auto-Assign Auto assign by bot bug This issue requires a change to an existing behavior in the product in order to be resolved. customer-reported Issues that are reported by GitHub users external to the Azure organization. Service Attention This issue is responsible by Azure service team. Service Connector az webapp/functionapp/springapp/containerapp connection Web Apps az webapp
Projects
None yet
Development

No branches or pull requests

7 participants