大网数据广告活动
服务器运维问答

Does my Oracle DBA need root access?

· 52CE 我爱测

My Oracle DBA Colleague is requesting root access on our production servers . He is arguing that he need it to perform some operations like rebooting the server and some other tasks. I do not not agree with him because I've set h…

问题原文

原帖链接 · Dr I · CC BY-SA 3.0

My Oracle DBA Colleague is requesting root access on our production servers.
He is arguing that he need it to perform some operations like rebooting the server and some other tasks.

I do not not agree with him because I've set him a Oracle user/group and a dba group where Oracle user belong. Everything is running smoothly and without the DBA having root access currently.
I also think that all administrative tasks like scheduled server reboot needs to be done by the proper administrator (The Systems administrator on our case) to avoid any kind of issues related to a misunderstanding of the infrastructure interactions.

I would like input from both sysadmins and Oracle DBAs - Is there any good reason for an Oracle DBA to have root access in a production environment?

If my colleague really needs this level of access I'll provide it, but I'm quite afraid of doing so because of security and system integrity concerns.

I'm not looking for pros/cons but rather advice on the how I should take to deal with this situation.

社区高分解答

原帖链接 · Giacomo1968 · CC BY-SA 3.0

In general—and not specific to DBAs—anyone who demands root access without giving a valid reason is either:

  1. Someone who doesn’t know what they are doing.
  2. Arrogant & uncooperative.
  3. Both of the above.

Now, there might be real reasons they need root access to handle their task, but again if they cannot explain why & put it in writing, I would not deal with them. Professionals who deal with servers understand & respect boundaries. Hot shots who know enough to get in trouble believe the rules apply to everyone but them.

In cases where I have had to tussle with folks like this, I have insisted that time be scheduled ahead of time so I could be on the server with them to handle issues as they arise. And this has actually worked well.

Another alternative—that might not be practical—is to create an exact clone of the server in question & give them root access on that. Be sure to change the password to something specific to them of course. Let them blow up an isolated development box.

But in general, if you are the one who will get called late at night to clean up a mess that this guy might create, then you have every right to say no to a blanket request for root access.

摘自公开归档,保留原文语言,版式经整理,外部媒体与邮箱地址已移除。

资料来源与适用范围

资料来源
Server Fault
适用范围
以原帖系统、软件版本与发布日期为准(2013-11-13)
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY-SA 3.0

正文与所需资源由本站本地存储。查看来源及更新记录 ↗

请按适用版本和实际日志确认原因;本站没有对每一种系统或设备逐项执行文中的操作。