Re: GRANT CREATE VIEW proble

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Wed, 29 Mar 2006 11:27:16 -0500
Message-ID: <o96dnXdqgIr6KLfZRVn-rQ@comcast.com>

<lukasz.stanczak_at_gmail.com> wrote in message news:1143649379.302999.304570_at_z34g2000cwc.googlegroups.com...
: Hi
:
: Is it possible to grant create view for owner only on tables in some
: schemes for example po, pu.
: Maybe user can grant creating views for owner on his objects? I know
: that user can grant object previliges on his objects, but is he able to
: grant creating views on this objects?
:
: greetings,
: Lukasz
:

typically, a user needs SELECT privilege on the object (direct grant, not via a ROLE) and CREATE VIEW privilege

this allows the user to create views which she owns

do you want a user to be able to create views owned by the user that owns the tables referenced in the views?

++ mcs Received on Wed Mar 29 2006 - 10:27:16 CST