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