db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dag H. Wanvik (JIRA)" <j...@apache.org>
Subject [jira] Updated: (DERBY-3073) SQL roles: add parser support
Date Thu, 04 Oct 2007 04:09:50 GMT

     [ https://issues.apache.org/jira/browse/DERBY-3073?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Dag H. Wanvik updated DERBY-3073:
---------------------------------

    Attachment: DERBY-3073b.stat
                DERBY-3073b.diff

This patch, DERBY-3073b, replaces DERBY-3073.

The previous version had some issues which are corrected in this version:

- Parser support for create synonym was accidentally broken in the first
  version.

- The look-ahead handling introduced to differentiate between granting of roles
  and granting of privileges was broken. The new version is hopefully adequate.

- A test is now included (lang/RolesTest.java). 

With this patch, the parser modifications should be completed as per the
specification in DERBY-2207, i.e. support for:

              - create role
              - drop role
              - grant role
              - revoke role
              - set role
              - current_role as value specification
              - current_role as column default

All new features presently give "not implemented" (0A000: NOT_IMPLEMENTED) at
run-time if running with sql authorization, otherwise an error message (42Z60:
LANG_GRANT_REVOKE_WITH_LEGACY_ACCESS) is given.

Also, for all new features, if the database is pre-10.4, level (in soft upgrade
mode), an error is given (XCL47: LANG_STATEMENT_UPGRADE_REQUIRED).

All regression tests pass, including the new test. 

As for the upgrade check, I have only tested manually so far. It will be added to upgrade
tests
later.

It is ready for review; I will appreciate any comments!


> SQL roles: add parser support
> -----------------------------
>
>                 Key: DERBY-3073
>                 URL: https://issues.apache.org/jira/browse/DERBY-3073
>             Project: Derby
>          Issue Type: New Feature
>          Components: SQL
>            Reporter: Dag H. Wanvik
>         Attachments: DERBY-3073.diff, DERBY-3073.stat, DERBY-3073b.diff, DERBY-3073b.stat
>
>


-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message