A method for allowing individual user entities access to tables in a database,
such as a DB2 database, in an isolated manner, that is, without interfering with
each other. For each original database table, DDL statements are employed to create
a new table. Within the new table are defined the same columns that are defined
in the original database table, as well as an additional column that includes a
User Identification. A view is created having the same name and column definitions
as the original database table, where the view selects only the rows in the new
table in which the User Identification matches a particular user entity. For each
particular user entity, access is allowed to the view for executing DML statements
of the application program without modification of the DML statements of the application
program other than for purposes of developing and testing functionality of the
application program.