No, you need to grant permissions only for the first time. If you decide to reconnect to Apple Health in the future, you will not be prompted for permissions again, as they will be granted automatically based on your previous choice. You can change your permission preferences in the Apple Health app.