Can't create a view for other user's table despite having select privilege I already executed the following commands:

grant create view to scott;
conn hr/hr;
grant select on employees to scott;


but I conn to scott:

create or replace view company_phone_book as
select employee_id emp_id, last_name||','||first_name name, phone_number, email
from hr.employees;


gives me the error:


  ORA-01031: insufficient privileges.
SCOTT will have the ability to expose the new view to other users, thus indirectly granting data access on HR to other users. SCOTT therefore needs WITH GRANT OPTION on the grant.

GRANT SELECT ON employees TO scott WITH GRANT OPTION;