Evaluate Weigh the pros and cons of technologies, products and projects you are considering.

Root script logging in as system then altering password: bad practice?

I have a script that is run as root. In this script, I start up Oracle, connect as internal, spool off the system password, alter system user identified by a known password, login as system and do my stuff, and then alter user system back to the original password after completing my tasks. Is this a bad practice? I am specifically wondering if there is a posibility that the system tablespace could get corrupted doing this. Any information is greatly appreciated.

While I can say that this is "bad", it isn't necessarily the best way either. Probably the best way to accomplish this is to set up your own account to do your work. Make sure that you grant the privileges you will need to get your work accomplished. Then have your root script sign on as that user. You don't have to monkey with changing SYSTEM's password at all.

For More Information

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.