Example of Privileges on the Violations Table

The following example illustrates how the initial set of privileges on a violations table is derived from the current set of privileges on the target table. Assume that a table named cust_subset consists of the following columns: ssn (customer Social Security number), fname (customer first name), lname (customer last name), and city (city in which the customer lives).

The following set of privileges exists on the cust_subset table:

User barbara has the Insert and Index privileges on the table. She also has the Select privilege on the ssn and lname columns.
User carrie has the Update privilege on the city column. She also has the Select privilege on the ssn column.
User danny has the Alter privilege on the table.

Now user alvin starts a violations table named cust_subset_viols and a diagnostics table named cust_subset_diags for the cust_subset table:

START VIOLATIONS TABLE FOR cust_subset
   USING cust_subset_viols, cust_subset_diags;

The database server grants the following set of initial privileges on the cust_subset_viols violations table:

User alvin is the owner of the violations table, so he has all table-level privileges on the table.
User barbara has the Insert, Delete, and Index privileges on the table.
User barbara has the Select privilege on five columns of the violations table: the ssn, the lname, the informix_tupleid, the informix_optype, and the informix_recowner columns.
User carrie has Insert and Delete privileges on the violations table.
User carrie has the Update privilege on four columns of the violations table: the city, the informix_tupleid, the informix_optype, and the informix_recowner columns. She cannot, however, update the informix_tupleid column (because this is a SERIAL column).

User carrie has the Select privilege on four columns of the violations table: the ssn column, the informix_tupleid column, the informix_optype column, and the informix_recowner column.
User danny has no privileges on the violations table.