1.) The user running the autoload doesn't have permission to update the metadata folder with the table. However, the user has RM, WM, WMM, etc permissions on the target folder.
2.) When logging onto VA Hub, the user gets an error about favourites not being retrieved from the Metadata. Turns out, the user can't create the Visual Analytics sub-folder under his home folder. Again, all the required permissions seem to be there.
3.) The Hub page is blank when logging on.
Now, when I add the user to the SAS Administrators group, all the above issues go aways instantly and the solutions works perfectly. I cannot think this is the correct way since we cannot make the end users all SAS admins.