Oracle/users and access
i have a user man1. scheduled scripts run on daily basis have password of man1 hard coded to it.i want restrict this man1 to just run these scripts and restrict other database access other than this.
simply i dont want any one accessing this user to log on to database but it should run the scheduled scripts.
is there any way
ANSWER: Hi Faiz,
Is this within the Oracle DB scheduler or on the server (Windows or Unix)?
Please let me know and I will try to help with a resolution.
---------- FOLLOW-UP ----------
QUESTION: on the server unix .Thank you
On the Unix server, you can use CRON (http://www.unixgeeks.org/security/newbie/unix/cron-1.html
) to schedule any actions that can be initiated through the Unix command line. that way only those scheduled jobs can run.
As an aside, hardcoding passwords in scripts are generally a bad ideal To safeguard the user/password account (it can be seen using the "ps -ef" command), use Oracle Wallet (https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:142212348066)
Make sure that your man1 Unix account is not shared by other human users. That too is a bad idea and can lead to other running your script by accident.
I hope this helps.