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.