June 2018
Intermediate to advanced
478 pages
10h 52m
English
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: