Re: need help on create view as select ...
- From: Bradd Piontek <piontekdd@xxxxxxxxx>
- To: mccdba1@xxxxxxxxx
- Date: Mon, 23 Nov 2009 19:22:52 -0600
I can think of two possibilities.
1. userA has not been granted the 'create view' privelege .
2. userA does not have direct 'select' privileges on userB.table1 (Grants
through a role won't be used via PL/SQL or Views)
Furthermore, if userA is going to grant privileges on the view, it will need
the 'with grant option' on the SELECT to userb.Table1.
Bradd Piontek
"Next to doing a good job yourself,
the greatest joy is in having someone
else do a first-class job under your
direction."
-- William Feather
On Mon, Nov 23, 2009 at 6:52 PM, dba1 mcc <mccdba1@xxxxxxxxx> wrote:
> 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:
