mugs

delete perm, perm-attrs and role-perm

Dec 14th, 2015
159
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.32 KB | None | 0 0
  1. DELETE FROM KRIM_ROLE_PERM_T WHERE PERM_ID  IN (SELECT PERM_ID FROM KRIM_PERM_T WHERE NM = 'Disable GL EDOC VAT calculation');
  2. DELETE FROM KRIM_PERM_ATTR_DATA_T WHERE PERM_ID IN (SELECT PERM_ID FROM KRIM_PERM_T WHERE NM = 'Disable GL EDOC VAT calculation');
  3. DELETE FROM KRIM_PERM_T WHERE NM = 'Disable GL EDOC VAT calculation';
Advertisement
Add Comment
Please, Sign In to add comment