Table and View Grants
Ingres allows data sharing and updating if users have been issued grant permissions on the tables or views used in the query.
Table and view permissions are enabling permissions—if no permission is granted, the default is to prohibit access. Table and view permissions are not enforced for the owner of the table or view.
Permissions on Tables and Views
The following query permissions can be granted on both tables and views:
Select
Enables grantees to select rows from the table or view, for example using a SELECT statement or a WHERE clause.
Insert
Enables grantees to add rows to the table or view, for example using an INSERT statement.
Delete
Enables grantees to delete rows from the table or view, for example using a DELETE statement.
Update
Enables grantees to change existing rows in the table or view, for example using an UPDATE statement. An update grant can apply to all columns in the table or view, or only to specific columns.
Permissions on Tables
The following query permissions can be granted on tables only:
Copy_into
Enables grantees to copy the contents of the table to a data file, for example using the INTO clause of the COPY statement.
Copy_from
Enables grantees to copy the contents of a file to the table, for example using the FROM clause of the COPY statement.
Modify
Enables grantees to modify the properties of a table using a MODIFY statement.
References
Enables grantees to create tables that reference the table. A references grant can apply to all columns in the table, or only to specific columns.
If a user is not the owner and does not have the references permission on a table, that user cannot create a referential constraint that references the table.
Last modified date: 08/28/2024