grantTablePermissions | R Documentation |
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
)
connectionDetails |
An object of type |
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 |
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.