Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Privilege to create views on my own schema based on tables in other schema
Are you using dot notation?
create view view1 as
select * from schema1.table1;
In article <8mq4j9$fv5$1_at_web1.cup.hp.com>,
"Maggie" <maggiezhou_at_hotmail.com> wrote:
> What is the privilege that I should have in order to create views on
my own
> schema based on tables on other schema?
>
> I already "select" privilege on tables in that schema and "create
view "
> privilege on my own schema. I tried to creat a view on my own schema
based
> on the table in other schema but I kept getting "table or view does
not
> exist" error message.
>
> Please help.
>
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Wed Aug 09 2000 - 00:00:00 CDT