Oracle FAQ

Your Portal to the Oracle Knowledge Grid

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

Home -> Community -> Usenet -> c.d.o.misc -> How to: create view A.myview as select * from B.table ??

How to: create view A.myview as select * from B.table ??

From: Christian Maier <tomtailor_at_freesurf.fr>
Date: 20 Mar 2006 04:23:46 -0800
Message-ID: <1142857426.527278.52820@i40g2000cwc.googlegroups.com>

Hello!

I am trying to create a view unter schema A which ist a select on schema B. But there occoures an "insufficient privileges" Error.

Which priviliges do I have to set?? I tried system and scott as sydba but no success.

THX! Christian Maier Received on Mon Mar 20 2006 - 06:23:46 CST

This message: [ Message body ]
Next message: Mark C. Stock: "Re: How to: create view A.myview as select * from B.table ??"
Previous message: ramprakash: "indexing issue, need alternate solution to improve the query performance"
Next in thread: Mark C. Stock: "Re: How to: create view A.myview as select * from B.table ??"
Reply: Mark C. Stock: "Re: How to: create view A.myview as select * from B.table ??"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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