db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Yip Ng" <yipng...@gmail.com>
Subject Re: [jira] Commented: (DERBY-1686) Grant/Revoke: Attempt to GRANT access to another user on a VIEW, created by the current user with only SELECT privilege on the base table does not fail
Date Fri, 01 Sep 2006 05:42:22 GMT
>On 8/31/06, Daniel John Debrunner <djd@apache.org> wrote:
>
>I think you are misreading it. It is saying if the GRANT statement is
>executed successfuly *AND* all of the conditions are met than an
>*additional* GRANT statement is executed.

You are right.  I missed the additional GRANT statement part...

Yip


On 8/31/06, Daniel John Debrunner <djd@apache.org> wrote:
>
> Yip Ng (JIRA) wrote:
>
> > 2)  GRANT SELECT ON V TO FRED
> >
> >     I cannot find any piece of info that is in 12.1 GR 4) that
> explicitly states it should return
> >     as failure or warning.  All it states is that if the conditions in
> GR 4) are met,
> >     then the grant statement is executed successfully.  I was inferring
> this implicitly
> >     that if it is not executed successfully then it is an error.
>
> I think you are misreading it. It is saying if the GRANT statement is
> executed successfuly *AND* all of the conditions are met than an
> *additional* GRANT statement is executed.
>
> It is not saying that all of those conditions need to be met in order to
> execute the original GRANT.
>
> Dan.
>
>
>

Mime
View raw message