Skip to content

feat: support sql GRANT/REVOKE privileges and ALTER USER Login/NoLogin options

Emir Vildanov requested to merge sql-grant-revoke-privileges into master

Summary

This MR introduces several SQL abilities to:

  • GRANT and REVOKE privileges
  • ALTER Login/NoLogin to user

Note: current logic of privileges checking and ACL execution is not full without default permissions(#385 (closed)) and additional access checks(!746 (merged)).

Follow-up doc issue: docs#125 (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
Edited by Emir Vildanov

Merge request reports