If an executive has the right to share an object, then any user will be able to request access from the executive.


That’s correct, users can request access from anybody who has permission to share the object. By default this will be the project owner or portfolio owner but users do have an option to select other users with sharing rights.