The SQL user must have the appropriate privileges (granted using GRANT) in order to install, use, or download a function or file. To manage users’ rights on a SQL-MapReduce function, the DBA or the function's owner uses the GRANT and REVOKE commands. These commands set the rules that govern who can install, run, download, and uninstall the SQL-MapReduce functions in each schema. For example:
| Task the user wants to do | Privileges the user must have to perform the task |
|---|---|
| Install a file | User must have the INSTALL FILE privilege on the schema where he wishes to install it. |
| Install a function | User must (a) have the INSTALL FILE privilege and (b) have the CREATE FUNCTION privilege on the schema where he wishes to install it |
| Run a function | User must have the EXECUTE privilege on the function. |
| Download an installed function or file | To download a file, the user must (a) have the USAGE privilege on the schema from which she wishes to download the file and (b) be the owner of the file (or be the database administrator). |
| Remove a function or file | To uninstall a file, the user must (a) have the USAGE privilege on the schema from which she wishes to uninstall the file and (b) be the owner of the file (or be the database administrator). |