Patent ID: 6951013

Claim:
A method for facilitating the development and testing, by a plurality of individual user entities, of a relational database application program which includes a plurality of Data Manipulation Language statements, which runs under a database management system and which accesses original database tables organized as rows of defined columns, said method comprising, for each original database table: employing Data Definition Language statements at least a first time to create a corresponding new table within which are defined the same columns that are defined in the original database table, and which includes an additional column that is defined to include a User Identification, and to define a view created having the same name and column definitions as the corresponding original database table, where the view Selects only the rows in the new table in which the User Identification matches a particular user entity; and for each particular user entity, allowing access to the view created by a match of the User Identification with the particular user entity for executing Data Manipulation Language statements of the application program, including statements to insert rows, without modification of the statements of the application program other than for purposes of developing and testing functionality of the application program.