I work with Database Administration and one of my roles is to make the environment safe. But on every company I've worked, there is a "star employee" - A guy that is a Dev normally, with little knowledge of database administration ( these guys knows how to code, but they knows very little about "database administration" ).
So every time I try to reorganize logins, users, limit their powers I face the
"noooo Mr. StarLight NEEDS sysadmin on EVERYTHING.".
I keep saying it's useless because he doesn't know what to do. I for sure will give him total access to all databases and features, but seems it's not enough.
In this last company, I just don't care anymore. I give sysadmin to whoever my boss asks because I'm tired of this same history. Don't get me wrong, I send an email pointing everything that can happen and how this is bad, but well I need a Job and not a fight.
How can I deal with this? Should I call these star guys and politely ask them to not mess around, and should I "teach" them how to properly use sysadmin powers if needed?