Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Privilege to create views on my own schema based on tables in other schema

Re: Privilege to create views on my own schema based on tables in other schema

From: <veraon_at_hotmail.com>
Date: 2000/08/09
Message-ID: <8mqset$46q$1@nnrp1.deja.com>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US