aRTconn-addPermission {aRT}R Documentation

Adds permission to a user

Description

Function to grant some permissions in a DBMS for a user. The aRTconn user must have permissions for doing this operation (Only root can do that).

Usage

## S4 method for signature 'aRTconn':
addPermission(object, user, pass, remote, host, privilege, db)

Arguments

object Object of class aRTconn.
user The username that will reveive the privileges.
pass The password for acessing the DBMS. Empty string if none (the default).
remote A boolean value, representing whether the DBMS will enable this connection from external hosts. Note that the DBMS must have external connections enabled.
host The external host to be acessed. If remote is true and host is empty string then the access is allowed from any host.
privilege Defines DBMS privileges. It must be one of "all", "select", "create", "alter" or "update". Execute addPermission repeatedly to combine two (or more) privileges.
db The target database. If it is empty string the user will have permissions to access all databases.

Author(s)

Pedro Ribeiro de Andrade

See Also

aRTconn-class shows the description of this class.


[Package aRT version 1.6-0 Index]