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 -> Privilege to create views on my own schema based on tables in other schema

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

From: Maggie <maggiezhou_at_hotmail.com>
Date: 2000/08/08
Message-ID: <8mq4j9$fv5$1@web1.cup.hp.com>#1/1

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. Received on Tue Aug 08 2000 - 00:00:00 CDT

Original text of this message

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