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

General
,
1

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.

2

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.