create view but insufficient priviledge
Hi,
I tried to create a view like below in 11.2.0.2
create or replace view test as
select grantee from dba_role_prives;
but it keep saying "insufficient priviledge", I had granted dba,create any view, under any view to the user,
but still no luck.
any one know what else priviledge have to grant to the user ?
Thanks
Vincent