IBM Support

Add OR REPLACE for masks and permissions

News


Abstract

Add OR REPLACE for masks and permissions

Content

You are in: IBM i Technology Updates > Db2 for i - Technology UpdatesDb2 for i Security Enhancements > Add OR REPLACE for masks and permissions

Similar to other Data Definition Language (DDL) statements, the OR REPLACE clause has been added to:

  • CREATE OR REPLACE MASK
  • CREATE OR REPLACE PERMISSION

The use of OR REPLACE makes it easier to re(deploy) Row & Column Access Control (RCAC) rule text.

Consult the IBM i SQL reference for details: CREATE MASK, CREATE PERMISSION 

[{"Business Unit":{"code":"BU070","label":"IBM Infrastructure"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB68","label":"Power HW"}}]

Document Information

Modified date:
25 March 2025

UID

ibm11167238