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

Mark C. Stock wrote:
> "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'

To OP: also, don't do "select *" in a view. This calls for trouble.

        robert Received on Mon Mar 20 2006 - 08:17:51 CST