How long before a new Patreon is given access?

If the user was already a patron when he signs up for Discourse the access is instant.

If the user becomes a patron after signing up for Discourse and you have webhooks configured the access is instant.

If the user becomes a patron after signing up for Discourse and you don’t have webhooks configured the access takes up to 6 hours.