schemamgr temp file chmod perms too restrictive umask

[markhu]

When you run schemamgr.pl , it outputs temp files with the permissions of you, the current user --which is fine until you run it as someone else, then it totally breaks.

The temp files either need deletion, or world-writeable/deletable permissions set, or a time-stamp added to the filename or PID stamp using the $$ pseudo-variable.

Here's what you see when it malfunctions:

sh: /tmp/DB_SCHEMA_VERSION: Permission denied
Current Schema Version:-1

Here are the occurrences in the code:

$ grep -n 'tmp/DB' schemamgr/bin/schemamgr_rc.pl 
143:    my $infile = "/tmp/DB_SCHEMA_VERSION";
171:    my $tmpfile = "/tmp/DB_UPGRADE_SCRIPTS";
208:    my $tmpfile = "/tmp/DB_UPGRADE_SCRIPTS";
263:    my $tmpfile = "/tmp/DB_UPGRADE_PROCEDURES";