Dynamic SQL does break the ownership chain established when exectuing the proc. A new ownership chain can be established later in the call stack but at the end of the day the login/user executing the proc only has the rights they have in the instance, i.e. Dynamic SQL will not elevate their rights in any way.