RE: [sqr-users] SQR Executed thru Process Scheduler

["the dragon" <ceprn@hotmail.com>]

If the sqr is executed through the process scheduler, regardless of who is 
executing it, it will run with the privs of sysadm.

OPRID is a security construct of PeopleSoft which is used for access.

peace,
clark 'the dragon' willis



PSA: Salary <> Slavery. If you earn a salary, your employer is renting your 
services for 40 hours a week, not purchasing your soul. Your time is the 
only real finite asset that you have, and once used it can never be 
recovered, so don't waste it by giving it away.

I work to live; I don't live to work.

"Time is the coin of your life. It is the only coin you have, and only you 
can determine how it will be spent. Be careful lest you let other people 
spend it for you."

Carl Sandburg
(1878 - 1967)

----Original Message Follows----

Hi,

    When a sqr is kicked off from a process scheduler, i  see that its 
getting executed as SYSADM user with SYSADM user privilege. If thats the 
case, then any inserts/updates/deletes to the table should be possible. So 
If any user (with only SELECT privilege) logs into the PIA page and kicks of 
the sqr thru process scheduler, then will the SQR be able to perform the 
same inserts/updates/deletes to the table? How will the OPRID come into 
picture?

Thanks
Ram

_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today - it's FREE! 
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/


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