User-Defined Function Editing Removes Existing Permissions
if you edit a user-defined functions, any pre-existing permissions are removed. They should not be.
2
votes
Riley Major
shared this idea
-
Riley Major commented
This continues to be an issue, but at least now the product warns you that "The object requires rebuilding, this may result in the loss of some properites." However, really the object doesn't require rebuilding. You could simply do an ALTER FUNCTION statement instead of recreating. And even if you had to recreate, you could also reapply all of the things (critically, permissions) which were originally attached.