Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
cancel
Showing results for 
Search instead for 
Did you mean: 

suid

David Bellamy
Respected Contributor

suid

hi all,

is it possible to give a regular oracle user oracle rites (shut or strtup)without him being root or oracle. is sticky bit a good way to go

tnx in advance
3 REPLIES
Rob Smith
Respected Contributor

Re: suid

Hi, you can do it by suid ing the commands you are talking about but if you are concerned about security you should procees carefully. You might want to look at sudo which allows the delegation of root privelages as well. Hope this helps.

Rob

Learn the rules so you can break them properly.
Brian Bientz
Advisor

Re: suid

Do you just want some users to be able to shutdown and startup the database without logging in as the "oracle" user? If so, as long as they are a member of the dba or oper group, they can startup and shutdown the database. Furthermore, you can grant SYSDBA and SYSOPER privileges to users so that they can perform some of these functions remotely.
Tim D Fulford
Honored Contributor

Re: suid

set uid is possible, with some security caveats.

I believe there is a default oracle group called something like dbasys or DBASYS. users in this group can do Oracle startups/shutdowns etc. This bypasses writing a suid script.
-