db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Deepa Remesh (JIRA)" <derby-...@db.apache.org>
Subject [jira] Updated: (DERBY-1582) REVOKE statement does not generate a warning when no privileges are revoked.
Date Thu, 10 Aug 2006 00:39:14 GMT
     [ http://issues.apache.org/jira/browse/DERBY-1582?page=all ]

Deepa Remesh updated DERBY-1582:
--------------------------------

    Derby Info:   (was: [Patch Available])

Thanks Dan for looking at the patch.

>From what I had tried, I had found that we have to keep track if any privilege is revoked
in TablePrivilegeInfo itself as addRemovePermissionsDescriptor is called multiple times in
TablePrivilegeInfo.executeGrantRevoke method. Because of this, we need to track whether or
not any privilege is revoked for table and routine separately. And we cannot move the whole
check to super class.

I think I should have added a common method to check and raise a warning if needed. I'll upload
a revised patch.

Please let me know if this doesn't sound okay.

> REVOKE statement does not generate a warning when no privileges are revoked.
> ----------------------------------------------------------------------------
>
>                 Key: DERBY-1582
>                 URL: http://issues.apache.org/jira/browse/DERBY-1582
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 10.2.0.0
>            Reporter: Daniel John Debrunner
>         Assigned To: Deepa Remesh
>         Attachments: d1582_v1.diff, d1582_v1.status
>
>
> SQL 2003 standard, section 12.7 <revoke statement>, item 17 under general rules
indicates the statement completes with the condition 'warning ? privilege not revoked.' when
no matching privilege is revoked.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message