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

Popular posts from this blog

android - getbluetoothservice() called with no bluetoothmanagercallback -

sql - ASP.NET SqlDataSource, like on SelectCommand -

ios - Undefined symbols for architecture armv7: "_OBJC_CLASS_$_SSZipArchive" -