oracle - Grant select previleges to a synonym -


--i'm using view named v_area , it's synonym: area however, when try grant select permissions role, following error:

grant select on area my_role

  • error @ line 1: ora-02225: execute , debug privileges valid procedures

i'm not using procedure, can do?

i've tryed use following grants:

grant select on area my_role; --this 1 gives above error grant select on 'area' my_role; --this gives other error  grant select on "area" my_role; --this gives same error 'area'  

edit:

i have 2 synonyms created named area: 1 view v_area , other ogc_area. no procedures involved

grant references user on base tables used in view using this

grant references on your_schema.tablename target_schema or user; 

Comments