...
Because the procedures themselves do not change, it was determined that a permanently installed Oracle package which contained the needed procedures would be the most efficient way accomplish the task. Execution rights to the package is given to a the KFS_ADMIN account created specifically to manage the roles. The KFS administrator would then use the KFS_ADMIN account to execute an Oracle PL/SQL script which utilizes the package. In this way the KFS administrator would be in control of when the user role updates were made, rather than creating Jira tickets and scripts for the DBA group to retrieve and execute.
...