In a Relativity database, a given group may have access rights or privileges to a table instance in order to perform SQL operations
such as SELECT, INSERT, UPDATE, or DELETE. Table privileges can apply to the whole table, or to each column of a table. If
the owner wants to grant access to only specific columns of a table, then use Column privileges, but to grant table-wide privileges
select one or more of the following:
- All - enabling the
All privilege allows all table privileges to the group
- Select - enabling the
Select privilege allows the group granted the privilege to access all of the columns of a specified table, including any columns
added to that table later.
- Insert - enabling the
Insert privilege permits the group granted the privilege to insert into all columns of a specified table, including any columns
added to that table later.
- Update - enabling the
Update privilege allows the group granted the privilege to update all columns of a specified table, including any columns added
to that table later.
- Refer - enabling the
Refer privilege allows the group granted the privilege to reference all columns of a specified table in integrity constraints,
including all columns added to that table later. 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.
- Delete - enabling the
Delete privilege permits the group granted the privilege to delete a row from a specified table. Since deleting a row of a relational
table is equivalent to deleting all columns of that row, this privilege exists only as a Table privilege; there is no corresponding
Column Delete privilege.
Each table privilege also has a
with Grant privilege (the
w/G tick-box), which enables the group to also grant that particular privilege to other groups when using Relativity DBA.