Собственно проблема
После переноса с localhost (XAMPP) на хостинг получаем:

Access denied

* warning: array_keys() [function.array-keys]: The first argument should be an array in /home/portal/modules/user.module on line 351.
* warning: implode() [function.implode]: Bad arguments. in /home/portal/modules/user.module on line 351.
* user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 query: SELECT DISTINCT(p.perm) FROM role r INNER JOIN permission p ON p.rid = r.rid WHERE r.rid IN () in /home/portal/includes/database.mysql.inc on line 120.

You are not authorized to access this page.

Настройки пользователей делались локально, далее бекап-ресторе на хостинг.