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":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB57","label":"Power"}}]

Document Information

Modified date:
21 January 2020

UID

ibm11167238