Job Submission help
Fri, 2007-11-09 17:02 — bud1960
Hi,
I am trying to understand how job submission works and wonder if anyone could either point me to a website or write something up to help me understand how it works. I have written some SQL scripts to put into job sub and I am attempting to use the runsqlplus program on Steve Rea's website, but am struggling how jobsub works.
Thanks in advance,
Bud
RE: Job Submission help
Hello,
Well, after much work, I have successfully implemented running SQL programs in Banner! If anyone is interested in the procedure, please email me and I will be glad to share it.
Have a great day!
Bud
Running Sql Programs in Banner
Have you come across permission issues when you try to update tables through a sql script? And did you find a work around besides giving the user update privileges on the table?
permissions on tables
You basically have three options:
1. grant the user update on the tables (not a good idea for security reasons)
2. log in as a super user, grant update on the table to the user, connect as the user - run the sql that does the update, connect back as super user and remove update privilege.
3. create a sqlrun user with update on just the tables necessary for your local scripts and run the sql under that user.
I have seen all three mechanisms used by clients but suggest 2 or 3 over 1.
---------------
Dave Hill, RTS Inc.
OCP Oracle DBA
www.rtsdba.com
--------------
Cherish the good times, endure the bad,
for this too will pass.
Permissions on tables
Thanks for your reply. However I still have a problem. We host banner for different institutions, and the DBA's don't want to have to update privileges for different users who may use this process. Which is understandable we have several scripts that several people at the institution would need to run. Also some of the universitys policy will not allow an "outside" script user to change users privileges. So I'm trying to discover a possible solution that will satisfy everyone.
Permissions on tables
lswaters -
Yes, you are looking at option 3 then :-) A generic user that can update only certain tables that need to be updated by local scripts. Your sql scripts would always connect as that user and then process the local updates.
Dave
---------------
Dave Hill, RTS Inc.
OCP Oracle DBA
www.rtsdba.com
--------------
Cherish the good times, endure the bad,
for this too will pass.
Job Submission
Can you share the procedures? my email is chayocampo@lycos.com.
We're having problem with our job submission on our production server. we have to manually restart banjobsub every hour or so...
Adding SQL scripts to run in Banner
Bud,
I am interested in the steps you took to add SQL scripts using runsqlplus. I tried to follow there steps as well, but no success. We are using a windows environment instead unix. I you don't mind I would like to receive your procedure to look over. By the way what envrionment are you guys using to run Banner?
thanks,
Steve
my email is steve.webb@lamarpa.edu