Grant Table Permissions — grantTablePermissions • ResultModelManager

Grant a given permission for all tables on a given tableSpecification

Very useful if you're hosting studies on data.ohdsi.org or other postgresql instances

NOTE: only tested on postgresql, users' of other platforms may have Sql translation issues

grantTablePermissions(
  connectionDetails = NULL,
  connection = NULL,
  tableSpecification,
  databaseSchema,
  tablePrefix = "",
  permissions = "SELECT",
  user
)

Arguments

connectionDetails: An object of type connectionDetails as created using the createConnectionDetails function in the DatabaseConnector package.
connection: DatabaseConnector connection instance
tableSpecification: data.frame conforming to table spec (must contain tableName field)
databaseSchema: database schema to run this on
tablePrefix: String to prefix table names with - default is empty string
permissions: permissions to generate must be one of SELECT, INSERT, DELETE or UPDATE
user: database user to grant permissions to