GRANT all rights on a (temp) table to schema admin

Source: R/utils.R

The SECURITY DEFINER functions do not have access to tables that are stored via dbWriteTable. Usage rights on these tables must be granted for them to be usable inside the db functions

db_grant_to_admin(con, table, schema = "timeseries")

Arguments

con

RPostgres connection object.

table

which table to grant rights on

schema

character name of the database schema. Defaults to 'timeseries'