igritco
7/4/2016 - 3:30 PM

Unlock account after password expired oracle

Unlock account after password expired oracle

ALTER USER SFC_ION IDENTIFIED BY sfc_dev ACCOUNT UNLOCK;
grant EXECUTE on SFC_ION.USERS to SALESEVENT;
grant EXECUTE on SFC_ION.EVENTS to SALESEVENT;
grant EXECUTE on SFC_ION.REPORTS to SALESEVENT;
grant EXECUTE on SFC_ION.CART_LOG to SALESEVENT;
grant EXECUTE on SFC_ION.CARTS to SALESEVENT;
grant EXECUTE on SFC_ION.CHANGE_LOG to SALESEVENT;
grant EXECUTE on SFC_ION.DEVICES_PACKAGE to SALESEVENT;
grant EXECUTE on SFC_ION.EXCHANGES to SALESEVENT;
grant EXECUTE on SFC_ION.FRANCHISEE to SALESEVENT;
grant EXECUTE on SFC_ION.PRODUCTS to SALESEVENT;
grant EXECUTE on SFC_ION.REPORTS_ADMIN to SALESEVENT;
grant EXECUTE on SFC_ION.VALIDATION to SALESEVENT;