Techniques for managing resources for multiple exclusive groups

A method for allowing an application designed to store data for one group of users to store data for a plurality of groups of users, the method comprising the steps of:

• modifying the application to cause the application to indicate data segregation criteria to a database server that stores data for the application;
• and
• in response to receiving a query that inserts one or more data items into a database object of the database from the application, submitted by a particular user, the database server performs the step of automatically adding to each data item inserted into the same database object one or more values that indicate how the particular user satisfies the segregation criteria,
• wherein the application is distinct from the database server.

A computer-readable medium carrying one or more sequences of instructions for allowing an application designed to store data for one group of users to store data for a plurality of groups of users, wherein execution of the one or more sequences of instructions by one or more processors causes the one or more processors to perform the steps of:

• modifying the application to cause the application to indicate a routine to a database server that stores data for the application in a database;
• wherein:
• the application is distinct from the database server;
• the routine provides modifications to queries of the database, the modifications limiting access based on the groups to which belong users that cause the queries to be submitted;
• and
• in response to receiving a query issued against a database object of the database caused by a particular user, the database server performs the steps of locating the routine, and
• prior to executing the query, modifying the query by invoking the routine to create a modified query issued against the same database object, thereby limiting access of the particular user to data that is associated with the group of users to which the particular user belongs.

A computer-readable medium for allowing an application designed to store data for one group of users to store data for a plurality of groups of users, wherein execution of the one or more sequences of instructions by one or more processors causes the one or more processors to perform the steps of:

• modifying the application to cause the application to indicate data segregation criteria to a database server that stores data for the application;
• and
• in response to receiving a query that inserts one or more data items into a database object of the database from the application, submitted by a particular user, the database server performs the step of automatically adding to each data item inserted into the same database object_one or more values that indicate how the particular user satisfies the segregation criteria,
• wherein the application is distinct from the database server.