I need your help DBAs, I need to know the pros and cons of my question.
We have this new "DBA", who doesn't know about DBA really, he got promoted to DBA temporarily to become an IT supervisor, He does not know any sql and no scripting skills.
He just took out all our developers' access to sql server to connect locally. I want to justify to our director that whatever this guy is doing is not comfortable for us..accessing the server and running the ssms.
Btw, he just changes access without even sending any courtesy emails. I need your advise on whether I'm wrong. I'm a developer for this company and for my past 10yrs, I've never worked in a company where you actually run your SSMS on the actual server.
Here's what I gather and my opinion.
- Risk to accidentally rebooting the SQL Server.
- Data security on the server.
I wish to add more so I can present this to my Director, I'm just not comfortable doing non-server stuff on the server period.