1

I have a SQL Azure instance and an associated user. The password of this user is stored as a Secret in Azure Key Vault.

Now, I have to hand over the connection string to this database to the Reports team for them to generate reports out of the database.

How can I hand this off so that the credentials are secure & the connection string does not actually store the password in a clear text format ?

Improve this question
1

1 Answer 1

Reset to default
1

One option is to use Azure AD Auth for your SQL instance. Then you can create specific user accounts for the BI team.

https://learn.microsoft.com/en-us/azure/sql-database/sql-database-aad-authentication

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.