Hey,
You should be able to run ‘VACUUM [tablename]’ on a specific table as a non-superuser but auto-vacuum should do most of the job. Why do you feel the need to vacuum your database manually? Have you noticed an issue with auto-vacuum?
Jérémy.
Render Support, UTC+3