Yes and no. If the user is an unregistered visitor to your website, their submission will be held in the moderation queue. However, if a user is a registered user on your website, logged in and they have been assigned a role, “Subscriber” by default, you can use the Connections : Roles admin page to give that role the permission to submit entries that do not require moderation.
