Abstract: The system and associated method utilizes a client computer (client), a server computer (server), and a database system. The client establishes communication with the server and submits a request for data to the server. The server receives the request and retrieves data from a column within a table of the database system in response to the request. The server then determines which rows within the column can be accessed by a user of the client. In this regard, the server includes a security information table having predefined values that indicate which rows of information within the database system are accessible to the user. The server analyzes these values in order to determine whether the user is authorized to access a particular row. The server then discards data associated with rows that the user is not authorized to access and transmits the remaining data to the client.

Abstract: A secure client/server system allows remote access to a database system without allowing unauthorized users to access data stored within the database system. A server receives a request for data from a client located at a remote location. The server translates the request for data into an appropriate query or queries. The queries are used by the server to retrieve data from databases associated with the server. If the requested data resides in a plurality of databases that utilize different protocols, the server submits a plurality of queries which are respectively compatible with the databases. Furthermore, if some of the information requested by the request for data is located in a remote database, the server creates a second request for data and transmits the second request for data to a remote server associated with the appropriate database. The remote server translates the second request for data into a second query and retrieves the requested data from the remote server with the second query.

Abstract: A method and apparatus for forms generation is disclosed including a central workstation on which a form layout is designed with forms generation software, is used to generate an object code output program which corresponds to the form layout. The object code output program can be utilized by independent workstations to print forms without requiring each independent workstation to be equipped with the forms generation software used by the central workstation to design the form layout.