In a Relativity database, a given group may have access rights or privileges to a column within a table. In order to perform
an SQL operation, such as SELECT, INSERT, or UPDATE on a column within a table, the user must belong to a group granted the
corresponding privilege for the columns affected by the operation.
The following Column privileges are available for a group:
- Select - enabling the
Select privilege permits the group granted the privilege to access specified columns of a specified table.
- Insert - enabling the
Insert privilege allows the group granted the privilege to insert into specified columns of a specified table.
- Update - enabling the
Update privilege permits the group granted the privilege to update specified columns of a specified table.
- Refer - enabling the
Refer privilege allows the group granted the privilege to reference specified columns of a specified table in integrity constraints.
Integrity constraints may be specified in CREATE TABLE statements and could be used in a way that would obtain information
about columns in another table for which a user would not otherwise have privileges.
Note: There is no Column Delete privilege because the SQL DELETE statement deletes a row of a table, thus requiring delete privilege
on all columns. You must use the Table Delete privilege described in Table Privileges to grant the privilege to delete rows
of a table.