Creating A Remote Access Utility To Allow Instant Updates To User Accounts In A Network Of Databases

The current process for making changes to user accounts in Akimeka databases requires more time—a week or more in some cases—,more steps, and more people than is desirable for a task that is required several times per day with only one person currently responsible for implementing those changes. We believe we can create an easy to use utility that will give individuals the ability to make their own instant updates to any available network database. We are writing SQL and PL/SQL code to create a series of database links along with procedures to read and write information to those databases. We are using Oracle Application Express to create a web based graphical user interface, driven by our SQL procedures, which will allow users to immediately accomplish a variety of tasks—create or edit database links, create new user ID’s, change passwords and set expiration dates, activate or deactivate accounts, and assign user roles and facility ID’s. We currently have a working prototype that can accomplish most of the intended tasks. Future work will be to achieve full functionality, demo the product to potential users, take feature requests, and polish the interface for intuitive use. Once complete, our product will allow users to accomplish a task that once might take a week, in minutes.