[
https://issues.apache.org/jira/browse/DERBY-3137?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12634574#action_12634574
]
Rick Hillegas commented on DERBY-3137:
--------------------------------------
Thanks for bringing my attention to the DERBY-3137-ijfix patch, Dag. It looks
good. For extra credit, someone may want to implement a similar command which
shows the session's role closure. It's a useful slug of information--that is,
other databases have bothered to implement the enabled_roles view defined in
chapter 11 of the SQL standard (InformationSchema). Thanks.
> 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.diff, DERBY-3137-ijfix.stat,
> 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-setRoleNoCNF-2.diff,
> DERBY-3137-setRoleNoCNF-2.stat, DERBY-3137-setRoleNoCNF-3.diff,
> DERBY-3137-setRoleNoCNF-3.stat, DERBY-3137-setRoleNoCNF.diff,
> DERBY-3137-setRoleNoCNF.diff, DERBY-3137-setRoleNoCNF.stat,
> DERBY-3137-setRoleNoCNF.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.
