What is the functional difference between these two commands?
ALTER DEFAULT PRIVILEGES IN SCHEMA schema_name REVOKE ALL ON FUNCTIONS FROM old_role;
ALTER DEFAULT PRIVILEGES FOR ROLE old_role IN SCHEMA schema_name
REVOKE ALL PRIVILEGES ON FUNCTIONS FROM old_role
Do they achieve the same thing, or is each one specifically doing something different? If so, what?
Thanks!