Grants on privileges in other schemas


Most people have discovered that even as SYS or SYSTEM, you cannot grant privileges on objects owned in another schema. For example, if you try

SQL> connect system/manager
Connected.

SQL> grant select on scott.emp to john;
then you'll get an "Insufficient privileges" error

To resolve this problem, a couple of options are