need help on create view as select ...
- From: dba1 mcc <mccdba1@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 23 Nov 2009 16:52:03 -0800 (PST)
We are login as "userA" and tried to issue following SQL command and failed.
create view table1 as select * from userb.table1;
ERROR at line 1:
ORA-01031: insufficient privileges
"userA" can run "select * from userb.table1;" without problem. I even grant
"dba" right to "userA". this "create View ..." still failed.
any ideal?
--
//www.freelists.org/webpage/oracle-l
Other related posts:
