Zberteoc
asked on
DBA and system access
A general question for DBAs:
Do the DBAs need admin rights on the boxes that run database servers, no matter what kind, or not?
Our operation guys say that we don't need that access nor do we need to even use RDC to connect to the servers in order to perform our DBA duties. Using the DBA tools like Enterprise Manager or Management Studio for MS-SQL, Toad or SQL Tools for MySQL and Oracle, should be more than enough, they say. With MySQL on Linux we use Putty to connect to the boxes or Toad to check or write code but we don't have admin rights on them.
I would like to hear opinions on this matter.
Thanks.
Do the DBAs need admin rights on the boxes that run database servers, no matter what kind, or not?
Our operation guys say that we don't need that access nor do we need to even use RDC to connect to the servers in order to perform our DBA duties. Using the DBA tools like Enterprise Manager or Management Studio for MS-SQL, Toad or SQL Tools for MySQL and Oracle, should be more than enough, they say. With MySQL on Linux we use Putty to connect to the boxes or Toad to check or write code but we don't have admin rights on them.
I would like to hear opinions on this matter.
Thanks.
ASKER
Who should be responsible with the installation/upgrade of the database softwares and service packs when needed, operation guys or DBAs.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
As with these question there is never a unique answer I awarded everybody with equal points as each answer can be considered as correct. All in all my question was answered and I thank all for your help. I wanted to give more points to the question but the system doesn't allow it.
In my opinion DBA's should have non-root access to the servers and some times he might need sudo access.
In the past couple of years I have observed this - what happens is when an operation guy gets frequent requests from dba group for small small tasks initially operation guy does this promptly.. this happens for sometimes and willingly or unwillingly operation guy has to give him admin rights so that in his absence dba can take care of tasks which he thinks dba can do...so one fine day operation guy decides to give him rights (sudo'ers list) ..