Standard users can't access AI

[drapado]

Describe the bug
The AI Chat and AI Tag functions (possibly others) are not appearing for standard user accounts but show up and work fine with the superuser account.

To Reproduce
Steps to reproduce the behavior:

Set up a model in the AI tab using the superuser account.
Create a standard user account and login. (this can be also done before setting up a model.
Try to access AI Chat or AI tag functionality.

Expected behavior
All functions should be available for all user accounts once enabled by the superuser.

Desktop (please complete the following information):

Docker Compose (1.6.3)
Ollama, openrouter

[dosubot]

The restriction on AI Chat and AI Tag for standard users is due to permission checks in the codebase—these features are gated by a requireAdmin property and related logic, making them available only to superusers. This is a known limitation and has been discussed in the project; while a maintainer mentioned a fix in the latest version, users report the issue still exists in Docker Compose 1.6.3. The backend code currently uses an authProcedure that only checks for authentication, not user role, so the restriction may also be enforced at the UI or configuration level. There is ongoing discussion about adding proper role-based access control to allow standard users access to all AI features once enabled by a superuser. For now, this behavior is expected and not a configuration error or model/provider issue. More details and discussion can be found here and here.

To reply, just mention @dosu.

---

^{How did I do? Good | Irrelevant | Incorrect | Verbose | Hallucination | Report 🐛 | Other}    

[drapado]

I solved it by changing the databse:

# Access the PostgreSQL container
docker exec -it blinko-postgres psql -U postgres -d postgres

# Once inside psql, run this SQL command to change user role to superadmin
UPDATE accounts SET role = 'superadmin' WHERE id = <user_id>;

# Or if you know the username:
UPDATE accounts SET role = 'superadmin' WHERE name = 'username';

# Verify the change
SELECT id, name, nickname, role FROM accounts;

# Exit psql
\q