Reputation: 2527
In Db2 for IBM i, I can create row permission like this.
-- enable row access control
ALTER TABLE QIWS.QCUSTCDT ACTIVATE ROW ACCESS CONTROL;
-- create permission MYPERMISSION999
CREATE PERMISSION MYPERMISSION999 ON SALES.ORDHED
FOR ROWS WHERE VERIFY_GROUP_FOR_USER(SESSION_USER,'MYGROUP') = 1
AND SCODE = SESSION_USER
ENFORCED FOR ALL ACCESS
ENABLE;
COMMIT;
ALTER TABLE SALES.ORDHED ACTIVATE ROW ACCESS CONTROL;
COMMIT;
If I Deactivate row access control, rules seem to go away, but if I ACTIVATE old rules come back.
ALTER TABLE SALES.ORDHED
DEACTIVATE ROW ACCESS CONTROL
Upvotes: 1
Views: 294