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

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Mon, 20 Mar 2006 08:16:24 -0500
Message-ID: <S9CdneKguNKxNoPZnZ2dnUVZ_u2dnZ2d@comcast.com>

"Christian Maier" <tomtailor_at_freesurf.fr> wrote in message news:1142857426.527278.52820_at_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
:

it's a matter of object privileges, not system privileges.

to create a persistent object (like a view or stored procedure) based on another schema's object (like a table) the creating schema needs directly granted privileges on the object -- privileges inherited via a role (other than PUBLIC) are not sufficient

so, you need B to issue 'grant select on xxx to A'

++ mcs Received on Mon Mar 20 2006 - 07:16:24 CST