Question Locked
0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have a DBA who is also a local administrator on the application server for the application he does DBA work for. He is also a local admin on his SQL server box. Is any of this inappropriate or create an SoD issue?
2 replies
by sdtate Accepted solution
Clarifications
by robo_dev Accepted solution
First of all, is there somebody else whose job it is to run the server, or is your DBA the guy?
If there is a separate team that does the server administration, then no, the DBA should not have root access to the server.
But, in small shops, there is no way to segregate duties when it's one person.
Normally the DBA should not have system access since he can get rid of logs or potentially something worse.
One way to fix it is to send logs to a separate server where he does not have root access.
This discussion is closed to new replies.
Trending Networks posts
Sort by Trending
Question Locked
Internet connection perfect on PC, not connecting anywhere else
0 helpful
4 replies
Question Locked
Using multi-NIC setup for NAS + router — better than VLAN?
0 helpful
4 replies
0 helpful
5 replies
Question Locked
Unknown device connected to my network
0 helpful
2 replies
Question Locked
How to change public IP without ISP?
0 helpful
2 replies