You can grant the user account the admin role on the host and they should then be able to login via SSH.
What are you trying to do via the console. You mention a regular user, but typically you don't give a regular user access to the console.
If you're using AD you can also integrate with AD to allow use of AD accounts, but those accounts would still require admin rights on the host to connect via SSH.