refactor: remove all privileges from role super

Summary

remove all privileges from role super and all grants on super

Close #410 (closed)

Ensure that

• New code is covered by tests
• API is documented
• Changelog is up to date
• (if Lua API changed) Lua API version is bumped in luamod.rs
• (if necessary) A follow-up doc issue is created in picodata/docs and linked here