Create Permit Statement

The Create Permit SQL 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.

Example: Create Permit

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

create permit select of employee to mildred;