Oracle PL/SQL/User Previliege/REVOKE REFERENCES

REVOKE REFERENCES ON Employee FROM Bob

--CASCADE CONSTRAINTS option
REVOKE REFERENCES ON Courses FROM Bob CASCADE CONSTRAINTS;