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: 04/03/2024