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.