fix: change role tuple auth field default value

Summary

Changed default value for auth field for role definition tuples from _pico_user system table.

Now default value same as for "admin" user definition.

---

• Close #567 (closed)
• Target branch: master
• Changes should be cherry-picked to 24.2: yes
• Docs follow-up: not necessary
• Follow-up for !894 (merged)