Ingres 11.2 | CREATE PERMIT Statement

SQL Reference Guide > SQL Reference Guide > F. 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.

CREATE PERMIT Example

The following example allows a user, Mildred, to select data from the employee table:

CREATE PERMIT SELECT OF employee TO mildred;

Last modified date: 08/28/2024