Skip to contents

Enable row level security on a table

Usage

rls_enable(con, table)

rls_disable(con, table)

Arguments

con

a DBI database connection object. required. supports only postgres and redshift connections

table

(character) a table name. required

Examples

if (FALSE) { # has_postgres()
library(DBI)
library(RPostgres)
con <- dbConnect(Postgres())
dbListTables(con)
rls_enable(con, table = "accounts")
rls_check_status(con, "accounts")
rls_disable(con, table = "accounts")
rls_check_status(con, "accounts")
dbDisconnect(con)
}