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-3137) SQL roles: add catalog support
Date Tue, 23 Sep 2008 15:35:44 GMT

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

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

    Attachment: DERBY-3137-ijfix.stat
                DERBY-3137-ijfix.diff

Uploading patch DERBY-3137-ijfix. It contains:

- a fix to ij's "SHOW ROLES" command to give an error message if the driver is 
  not Derby embedded or client. The command does not use database metadata, 
  so the generated select from SYS.SYSROLES is inherently Derby specific.
- a new simple test for the command, tools/ij_show_roles.sql (run via
  JUnit/ToolScripts.java). The test is run both the embedded and via the network client.
- a fix to escape CNF role names to protect the role id when performing DROP ROLE in
  CleanDatabaseTestSetup#removeRoles (the test above provoked this bug).

Running regressions now.

> SQL roles: add catalog support
> ------------------------------
>
>                 Key: DERBY-3137
>                 URL: https://issues.apache.org/jira/browse/DERBY-3137
>             Project: Derby
>          Issue Type: Task
>          Components: Security, SQL
>            Reporter: Dag H. Wanvik
>            Assignee: Dag H. Wanvik
>             Fix For: 10.5.0.0
>
>         Attachments: DERBY-3137-2.diff, DERBY-3137-2.stat, DERBY-3137-2.txt, DERBY-3137-ijfix.diff,
DERBY-3137-ijfix.stat, DERBY-3137-rename-b.diff, DERBY-3137-rename-b.stat, DERBY-3137-rename.diff,
DERBY-3137-rename.diff, DERBY-3137-rename.stat, DERBY-3137-rename.stat, DERBY-3137-uuid-2.diff,
DERBY-3137-uuid.diff, DERBY-3137-uuid.stat, DERBY-3137.diff, DERBY-3137.diff, DERBY-3137.stat,
DERBY-3137.txt
>
>
> As a next step after adding support for the roles syntax, I intend to
> make a patch which implements catalog support for roles,
> cf. SYS.SYSROLES described in the specification (attached to
> DERBY-2207). Also the patch should tie this support up to the parser
> support, so the role statements can be executed. Any privileges
> granted to roles would still have no effect at run-time.

-- 
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