The DBA at a customer's site is unwilling to provide me with SA or Windows authentication access for the upgrading of DC RUM to 12.3.3.
Instead, he is only willing to create a temporary user for me to conduct the upgrade and subsequently delete the user after the upgrade has been completed.
I initially asked for the same rights access as the SA but his security concerns is that other Databases located in the same DB server may get affected and it is not in their policy to pass out SA access.
Is there documentation somewhere which details the exact roles needed (E.g. DBOwner, ServerAdmin, etc) for me to pass it to him to create a temporary role?
And what are the implications is the temporary user is deleted after the upgrade is complete?
Would appreciate any help!
So you met one of those guys that Thinks his own shadow will attack him
There is usually 2 ways of dealing with this:
And good luck