B. SQL Statements from Earlier Releases : Create Permit Statement
 
Share this page                  
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.