Methods and systems are disclosed for providing a database schema that links various system components and information to provide oversight and automated access control across disparate systems and applications. In one implementation, the database schema may use separate centralized tables to tie the various system components and information together. For example, one table may store information concerning technical support personnel authorized to address a given technical support incident, and another table may store information concerning approval given to do the technical support personnel to access a resource needed to provide the technical support, and the level of access needed to address provide technical support. Auxiliary tables may then be provided to support the centralized tables. Such an arrangement has a number of advantages, including the ability to allow the technical support personnel to access user ID-protected and/or password-protected systems/applications without using or knowing the user IDs and passwords.