I have a SQL Server 2017 database which contains some CLR stored procedures. When trying to call those CLR SP's, I get a "login failed" error back from the CLR SP.
My user is connected and works fine - it seems that the CLR SP is coded to run as another specific user.
I don't have access to the underlying code for the CLR SP's. Is there any way for me to change which user it's executing as?