Friends,
As a SYSDBA or DBA user, How to grant DML permissions on a table
of one schema to another schema. Is it possible ?
Example:
SQL> connect sys as sysdba
Enter password: *********
Connected.
SQL> grant update on scott.emp to hr;
grant update on scott.emp to hr
*
ERROR at line 1:
ORA-01031: insufficient privileges