mfdb_sharing: MareFrame DB sharing options

In mfdb: MareFrame DB Querying Library

MareFrame DB sharing options

Description

Alter database privileges

Usage

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

## Not run: # 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

## End(Not run)

mfdb documentation built on June 21, 2022, 5:07 p.m.