@Espenol1 
dbmanagedidentity is a workspace level and I totally agree that it's not a perfect way of dealing with the authentication.

With managed identities - they are designed to communicate with services without using secrets at all, so it's impossible. The only way at the moment is to use service principal.

View solution in original post