I am employed as GIS Administrator here in our Local Government office.
Recently our permissions within the server have been reviewed and due to company policy the "Processadmin" role and the "CREATE FUNCTION", "CREATE PROCEDURE", "CREATE TABLE", and "CREATE VIEW" permissions also removed as it is a company security risk.
I have been asked to provide reasoning as to why I should have these permissions.
The only thing I can think of is for disconnecting users, are there other reasons I am not thinking of?
The majority of my work is being done as the Data Owner, this has been unaffected and still works fine.
Any suggestions or comments are greatly appreciated.