System and method for secure and scalable database transactions over a network

A secure and scalable system and method is described for carrying out database transactions over a network. A transaction server on a network authenticates a user connected to the network with a client. The database access permission of the user is determined, and the transaction server sends a graphical user interface that comports with the access permission of the user to the client. The transaction server receives a user database request from the client based upon inputs provided by the user through the graphical user interface. The transaction server selects an action statement with formal parameters based upon the user database request. The action statement is evaluated by replacing its formal parameters with values from the user database request. The evaluated action statement is executed on a database, and the results are sent to the client, where they are displayed to the user through the graphical user interface.