Is there a way of granting database privileges from R (e.g. using DBI)?

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.

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.