--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
Post a Comment