I have 2 users in the database, userA and userB.
UserB has the DML priviliges (SELECT, INSERT, UPDATE, DELETE) for all the tables under userA.

I was wondering if the userB can have DROP and CREATE FOREIGN KEYs of userA. If YES, what would be right GRANT command???

The reason is, for some cases in our application, userB has to delete certain data and to make FKs error simple, we want to DROP FKs, Delete the data, Insert new data, and re-create FKs.

Thanks in advance!