Run DB As Non_Root User

[kpr]

We're running Progress V 91D on Solaris V 7. I need to run the Progress
databases under a non-root user(progress) and am interested in hearing
from someone that's done this successfully. My thought was that the file
ownership should be changed for /opt/dlc91d ,/opt/dlc91d/bin,
/opt/dlc91d/probuild/eucapp, /opt/SUNWexplo/bin, /usrs/opt/dlc91d from
"root" to "progress" and that the group would be changed from "other" to
"dba".

What I'm looking for is anything that I might be missing. Any suggestions
will be appreciated.

Thanks,

KR

 

[BruceD Lindberg]

not sure

the executables need permissions
-xsrx-rx-r

I think this allows it to gain root priveledge and to access shared memory. Accessing the DB's shared memory is critical.

 

[jwhiteho]

We started out a couple years ago running our dev/test databases as a user other than root (we also used "progress"). Our Unix Admin spent a good deal of time identifying what needed to be changed and making the changes. We've been running those environments for a couple years this way.

Before long though we realized that every subsequent upgrade or patch was going to cause issues since we'd have to go through and change permissions, etc. again. We made the decision that all other installations (uat, training, production, etc.) would be owned and run as the "root" user which is what Progress supports. Just this past week I upgraded our dev/test environments and reverted them back to being run as "root".