USING SAP ERP AND ORACLE DBMS TOOLS TO DEMONSTRATE AUTHORIZATION CONCEPTS

2009 Issues in Information Systems  
This paper discusses our development and use of course material to demonstrate database management systems concepts to students by using enterprise resource planning (ERP) system software to augment their learning. The purpose of our paper is to share our experience with other universities interested in using ERP software as a tool to supplement students' learning of information technology (IT) concepts as they may apply to an organizational setting. This paper describes the course material and
more » ... course material and tutorial we developed to facilitate students' understanding using a hands-on approach. We used Oracle as our relational database management system (DBMS) and SAP R/3 as our ERP system. Students first learn the structure of SQL syntax and the specific commands that would enable them to create users and roles, and grant permissions. They then practice the SQL syntax that they learned by executing the commands in an actual DBMS. Then the students learn how to create user accounts and grant transaction authorization by using the tools provided by the Oracle DBMS system. And finally the students learn how to create user accounts and grant transaction authorization by using the tools provided by the ERP system. These same concepts can be applied to other relational DBMS such as Microsoft SQL Server and other ERP systems. Experiential learning theory provides the guiding framework for our approach.
doi:10.48009/1_iis_2009_115-125 fatcat:hzdi5c6fibe4fdjdpz3ipfq35q