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). Note that the default Windows installation requires a password, otherwise it will print the error `Cant find any matching row in the user table`.
`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.7-1 Index]