SQL>  GRANT ALTER, DELETE, INSERT, SELECT, UPDATE ON scott.emp to hr with grant option;

Grant succeeded.

SQL> GRANT ALTER, DELETE, INSERT, SELECT, UPDATE ON scott.emp to hr ;

Grant succeeded.




SQL> create or replace view scott.emp_vue as select * from scott.emp;

View created.

SQL> GRANT ALTER, DELETE, INSERT, SELECT, UPDATE ON scott.emp_vue to hr;
GRANT ALTER, DELETE, INSERT, SELECT, UPDATE ON scott.emp_vue to hr
                                                     *
ERROR at line 1:
ORA-02204: ALTER, INDEX and EXECUTE not allowed for views


SQL> GRANT ALTER, DELETE, INSERT, SELECT, UPDATE ON scott.emp to hr with grant option;

Grant succeeded.


SQL> ! oerr ora 2204
02204, 00000, "ALTER, INDEX and EXECUTE not allowed for views"
// *Cause:  An attempt was made to grant or revoke an invalid privilege on a view.
// *Action:  Do not attempt to grant or revoke any of ALTER, INDEX, or
//          EXECUTE privileges on views.

SQL> 

SQL> show user
USER is "SYSTEM"
SQL> select banner from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
PL/SQL Release 11.1.0.6.0 - Production
CORE    11.1.0.6.0      Production
TNS for Linux: Version 11.1.0.6.0 - Production
NLSRTL Version 11.1.0.6.0 - Production