Advertisement
mugs

delete all perm, perm-attrs and role-perm

Dec 15th, 2015
112
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.37 KB | None | 0 0
  1. DELETE FROM KRIM_ROLE_PERM_T WHERE PERM_ID  IN (SELECT PERM_ID FROM KRIM_PERM_T WHERE NM LIKE 'Disable VAT calculation%');
  2. DELETE FROM KRIM_PERM_ATTR_DATA_T WHERE PERM_ID IN (SELECT PERM_ID FROM KRIM_PERM_T WHERE NM LIKE 'Disable VAT calculation%');
  3. DELETE FROM KRIM_PERM_T WHERE NM LIKE 'Disable VAT calculation%';
  4.  
  5. DELETE FROM DATABASECHANGELOG WHERE id LIKE 'NWUKFS-2686%';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement