automating exp

[penzk001]

I have need to perform automated full dataabse exports, the script works fine however I do not want to put the password in the script.
Is there a way I can do that ? I informix, you need to use the OS account informix was installed with.

 

[alexhu]

There should be no problem in putting the password in the script, PROVIDING only the correct users have access to it.

What platform are you on ?

Alex

 

[penzk001]

I would prefer to not to put the password in the text file as, on this server there is a 3rd party application and from time to time, the supplier connects to it using a VPN connection. The operating system is AIX 4.3.3.

 

[alexhu]

So your 3rd party has access to the Oracle user password ?

Alex

 

[penzk001]

No, he had no had the oracle password, but some times with our system administrators they access the machine with root privileges to add /resize application partitions.

 

[alexhu]

Well, if you're giving away root, it hardly matters about any password anywhere - its accessable!

When I need to give away the root password (to engineers usually) I change it for their use and then change it back, so that the system is again secure - suggest your admins do something similar

Alex

 

[sem]

Is it necessary to connect as root to administer applications? Can you create a user with sufficient rights for this purpose? Similar to oracle:dba?

Regards, Dima

 

[penzk001]

The system, is secure as only the system adminsitrators access the system with root privileges, when a external supplier call in, the supplier uses its temp account and root commands as passed to systems people. To be review/executed by them, so to this extent the system is secure.

 

[alexhu]

Then if the script can only be read by the Oracle user, there is no problem in putting the password in the script is there ?

Alex

 

[penzk001]

Yes, I thought that there was a way I could do it.

 

[alexhu]

You could put the password in the database and extract it, but if you have root, you can still get it

Alex