Oracle Job does not work with tables under Oracle Label Security -
i have database schema myuser under oracle label security (ols) , job myuser.myjob executing procedure myuser.myproc, selects or updates tables in myuser schema. user myuser dba, has full ols privileges, myjob , myproc owner , caller, myjob not work. starts, calls myproc, procedure myproc begins, nothing , ends in 0.01 second without message.
but when execute same myproc pl/sql block, out of job, works well. seems myproc executes no access rights myuser tables.
could tell me may reason , put light solve issue?
Comments
Post a Comment