Revert "Merge pull request #27636 from mtsmfm/disable-referential-integrity-without-superuser-privilege-take-2"

This reverts commit c1faca63, reversing
changes made to 8c658a0e.

See https://github.com/rails/rails/pull/27636#issuecomment-297534129