We execute code to grant PEIMS File Loader permissions to users who have the authorization to load PEIMS files. Here are the steps:
1. The user must have PEIMS user variables first (in NexGen as of August 2018).
2. Execute this SPROC and update the following:
a. Use either TX_CertifyRepository or EE_CertifyRepository depending on the location of the user.
b. @USERNAME to be that of the user that you are granting access.
@USERNAME = 'XXXXX'
3. You will see the following, if successful:
(0 row(s) affected)
(1 row(s) affected)
TSDS File Loader permissions successfully granted to user XXXXX