So something like this, but through R, using DBI or another package on a PostgreSQL database. I have admin privileges, but want to do it through R as it fits with the workflow better.
GRANT USAGE ON SCHEMA schema_name TO username;
I have tried a few things like
DBI::DbExecute() but they don't seem to work - not designed for that. Any ideas? No error message, but it doesn't grant the priviliges.