The ALTER PERMISSION statement alters a row permission that exists at the current server.
This statement can be embedded in an application program or issued interactively. It is an executable statement that can be dynamically prepared only if DYNAMICRULES run behavior is implicitly or explicitly specified.
The privileges held by the authorization ID of the statement must include SECADM authority.
Enables the row permission. If row level access control is not currently activated on the table, the row permission will become effective when row level access control is activated on the table. If row level access control is currently activated on the table, the row permission becomes effective immediately and all packages and dynamic cached statements that reference the table are invalidated.
ENABLE is ignored if the row permission is already defined as enabled.
Disables the row permission. If row level access control is not currently activated on the table, the row permission will remain ineffective when row level access control is activated on the table. If row level access control is currently activated on the table, the row permission becomes ineffective immediately and all packages and dynamic cached statements that reference the table are invalidated.
DISABLE is ignored if the row permission is already defined as disabled.
ALTER PERMISSION P1 ENABLE
ALTER PERMISSION P1 DISABLE