Ingres 11.0 | Create Permit Statement

SQL Reference Guide > SQL Reference Guide > B. SQL Statements from Earlier Releases > Create Permit Statement

Was this helpful?

Create Permit Statement

The Create Permit statement defines permissions for a table or view.

This statement has the following format:

CREATE PERMIT oplist ON | OF | TO table_name[corr_name]

[(column_name {, column_name})] TO user_name

optlist

Specifies a comma-separated list of operations. These operations include the following:

• SELECT

• UPDATE

• DELETE

• INSERT

• ALL

column_name

Can only be specified when the oplist value is UPDATE.

user_name

Specifies the login name of a user or the word ALL (meaning all users in this argument).

By default, the owner of the table has permission to perform ALL operations on the table.

Note: Permits created on a table must be grant-compatible to allow a user to access the table. Grant-compatible means that the text of the CREATE PERMIT statement can be expressed as a GRANT statement without any loss of information. The syntax of CREATE PERMIT presented above is grant-compatible. However, permits created with the CREATE PERMIT syntax documented prior to Release 6 may not be grant-compatible.

Last modified date: 01/30/2023