Question Locked

Auditing Administrative Access

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 robo_dev

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.