602SQL Documentation Index  

Column Privileges after Modifying a Table Structure

All privileges to unchanged columns are preserved after table modification, including both privileges granted to columns in the entire table and privileges granted to columns in individual records (if it is enabled).

If the column type or other properties of the column has changed (e.g. the length or the default value), the privileges remain unchanged.

When a new column is created, the user who modifies the table structure and the standard roles Administrator and Senior_user are granted the privilege to read/write to the column. The standard role Junior_user is only granted the privilege to read the column. This rule affects global privileges valid for all records in the table. No privileges for new individual records are granted to these subjects.

If a column is renamed, the privileges are discarded and new privileges are assigned according to the rule for new columns.