oracle - grant update on table in different scheme -

oracle - grant update on table in different scheme -

i have 3 schema's in database:

colldesk - main account local_it - local business relationship developments user - user account

now writing procedure grant people access based on job. depending on job, need select, or select, update, insert , delete privileges on tables.

i know create roles this, can't (dba's external, , don't roles.......)

when running procure, inserting new user, , section belong to. if section it_support example, need able update tables in business relationship account , local_it account. procedure located in local_it account.

now, when trying run script like:

for x in (select * all_objects owner in ('colldesk','local_it') , object_type in ('table','view') , object_name not in ('ifm_letter_data','ifm_letter_data_v2') order owner asc) loop execute immediate 'grant update on ' || x.owner || '.' || x.object_name || ' ' || v_user; end loop;

i getting error, saying have insufficient privileges. possible grant update privileges on table in different schema? able grant select privileges.

thanks lot in advance

look @ this: have friend trust , gave him key appartment. ok if friend give re-create of key friend?

it might no, might yes.

when want grant permissions user may ok user share access others.

so, in case:

user tables should grant access tables, permissions share:

grant update on my_table grant alternative

then can manage access table.

oracle updates grant