File Management Functions | Teradata R Package - 17.00 - File Management Functions - Teradata R Package

Teradata® R Package User Guide

prodname
Teradata R Package
vrm_release
17.00
created_date
November 2020
category
User Guide
featnum
B700-4005-090K

To work with file management functions, a user must be granted specific permissions and additional permissions on the user's database.

  • Permissions to the user.
    For example, if the user is 'TDAPUSER, the following permissions are required':
    • GRANT EXECUTE PROCEDURE ON SYSUIF.INSTALL_FILE TO TDAPUSER;
    • GRANT EXECUTE PROCEDURE ON SYSUIF.REPLACE_FILE TO TDAPUSER;
    • GRANT EXECUTE PROCEDURE ON SYSUIF.REMOVE_FILE TO TDAPUSER;
  • Permissions to the user on the user's database.
    For example, if the user is 'TDAPUSER' and the database is 'TDAPUSERDB', the following permissions are required:
    • GRANT CREATE EXTERNAL PROCEDURE ON TDAPUSERDB TO TDAPUSER;
    • GRANT DROP PROCEDURE ON TDAPUSERDB TO TDAPUSER;