Hey all,
Say I want developers to create schemas with authorization to dbo ... is the only way to accomplish this by granting impersonate to the calling user/role to dbo? If so, what exactly does this do? I'm reading that this will also grant db_owner privileges? I don't believe this to be true though. I did a quick test case only granting a user impersonate to dbo and that user was not able to create a schema until I gave it db_ddladmin. So I guess at this point I'm simply trying to better understand exactly what granting impersonate to dbo does.
Thank you