Privileges thoughts

[sckott]

Question is: is there anything we can do to make privileges easier?

Postgres docs: https://www.postgresql.org/docs/current/ddl-priv.html

Taking some inspiration from https://github.com/codenize-tools/gratan?tab=readme-ov-file#grantfile-example one could do something like this

# for the grant statement of (where table name is "passwd")
dbExecute(con, "GRANT UPDATE
  (pwhash, real_name, home_phone, shell)
  ON passwd TO public"
)

# we could have (using NSE)
user(public) %>% 
  on(passwd, columns(pwhash, real_name, home_phone, shell)) %>% 
  grant(update)

though I think our little DSL would only want to handle simple cases if we do it

[sckott]

work on priv branch https://github.com/getwilds/rls/tree/priv

[sckott]

closing - subsumed within #4