MareFrame DB sharing options — mfdb

Alter database privileges

mfdb_share_with(mdb, user_or_role, query = TRUE, import = FALSE)

Arguments

mdb: (required) A database connection created by mfdb()
user_or_role: (required) Another database user, or a role, or 'public' to share with all users
query: Should the user be able to query the current case study?
import: Should the user be able to import more data current case study?

Details

This allows you to share case study data between users. This is most useful when using a shared database. Only the owner of the schema (i.e. the user that created it) will be able to change table structure (i.e. upgrade MFDB versions).

By default nothing is shared between users.

Value

NULL

Examples

if (FALSE) # NB: Requires a PostgreSQL installation, and creation of extra users

mdb <- mfdb('examples')

mfdb_share_with(mdb, 'gelda') # Allow DB user gelda to query the 'examples' case study data
#> Error in mfdb_db_backend(mdb): object 'mdb' not found