Re: [sqr-users] Help in setting up an encrypted password

[Al H <star111lists@mindspring.com>]

The only real "secure" way to deal with this issue is to set up a
non-sysadm account with grants and synonyms that the developers could
run their SQR's through, or to use some kind of front end execution
program that has the password hidden in it.  If you are using
PeopleSoft, Process Scheduler does this for you.  

The reality is that if an SQR is to run using the system password,
then the developer of the SQR pretty much has all the power of the
account anyway so its a rather futile effort.

On Tue, 7 Jan 2003 14:11:58 -0500 , you wrote:

>Has anybody encrypted the SYSADM PeopleSoft password so developers can run
>their SQRs from the UNIX prompt??
>
>I am creating an OPS$PASSWORD user in Oracle to store the PeopleSoft SYSADM
>password in a table. I need to encrypt this password in Oracle. 
>
>How do I pass this password to run SQRs from the UNIX prompt$
>
>Any help with writing this would be appreciated.
>
>Thanks,
>Jodi
>
>Jodi Langdon
>Standard Register Company
>jodi.langdon@standardregister.com
>(937) 221-3452 - Work
>
>
>_______________________________________________
>sqr-users mailing list
>sqr-users@sqrug.org
>http://www.sqrug.org/mailman/listinfo/sqr-users


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users