A user with SECADM authority can create row permissions on a table by using the CREATE PERMISSION statement. The basic syntax is:
CREATE <OR REPLACE> PERMISSION [PermissionName] ON [TableName]FOR ROWS WHERE [SearchCondition] ENFORCED FOR ALL ACCESS<ENABLE | DISABLE>
In the preceding syntax, the following applies:
- PermissionName: Identifies the name of the permission, including the explicit or implicit qualifier.
- TableName: Identifies the name of the table on which to create the row permission. It must not be: a nickname; a created or declared global temporary table, view, alias, or synonym; a typed table; or a system catalog table.
- SearchCondition: Identifies a condition that can be true or false for a row of ...
