I hope everyone's doing well. I had a one line script to assign access to something:
GRANT privileges ON object TO user;
My co-worker, Senior Database Developer said instead it should be:
REVOKE Execute ON object TO user;
GRANT Execute ON object TO user;
He said this was a 'safety' thing and that we should take the privilege away before granting it. Essentially a best practice thing.
I searched this up and couldn't find anything. Has anyone experienced this or heard of this before? i.e. requiring a Revoke before Grant