GRANT ALL PRIVILEGES ON *.* TO sa;
GRANT ALL PRIVILEGES ON *.* TO jboss;

GRANT EXECUTE ON FUNCTION oms_login TO init IDENTIFIED BY 'init';
GRANT EXECUTE ON FUNCTION oms_login TO jboss IDENTIFIED BY 'jboss';
GRANT EXECUTE ON FUNCTION oms_login TO sa IDENTIFIED BY 'Mr.Turing';

GRANT EXECUTE ON FUNCTION oms_getSystemPass TO init;
GRANT EXECUTE ON FUNCTION oms_getSystemPass TO sa;

GRANT EXECUTE ON FUNCTION oms_chgpass TO init;
GRANT EXECUTE ON FUNCTION oms_chgpass TO jboss;
GRANT EXECUTE ON FUNCTION oms_chgpass TO sa;

GRANT EXECUTE ON PROCEDURE oms_unlock TO jboss;
GRANT EXECUTE ON PROCEDURE oms_unlock TO sa;

GRANT SELECT,INSERT,UPDATE,DELETE ON TABLE v_contact TO jboss;
GRANT SELECT,INSERT,UPDATE,DELETE ON TABLE v_contact TO sa;

GRANT SELECT on oms_sch_model TO init;

FLUSH PRIVILEGES;
