PL/SQL Synonym and Grant

grant select on table_name to schema_name;

grant select on seq_name to schema_name;

grant insert on table_name to schema_name;

grant update on table_name to schema_name;

grant execute on schema_name_x.pkg_package_name to schema_name_y;

------

create or replace synonym schema_name_2.table_name for schema_name_1.table_name;

drop sysnonym schema_name_2.table_name;


Comments

Post a Comment

Popular posts from this blog

Solution for the fault: "System.Diagnostics.Process.Start is not working on IIS, but working on ASP.NET Development Server"

Solution for "Can not obtain Oracle client information from registry"