[ https://issues.apache.org/jira/browse/DERBY-3137?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12658106#action_12658106 ]
Rick Hillegas commented on DERBY-3137: -------------------------------------- Thanks for the patch, Dag. I notice that the other cases (USER, CURRENT USER, SESSION USER, SYSTEM USER, CURRENT SCHEMA) use DataDictionary.TYPE_SYSTEM_IDENTIFIER as the type of a SQL identifier. Do you think that these other cases should agree with CURRENT ROLE? Do we need to log a bug against the other cases and recommend CURRENT ROLE as a better model? > 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-current_role_type.diff, DERBY-3137-current_role_type.stat, > DERBY-3137-ijfix.diff, DERBY-3137-ijfix.diff, DERBY-3137-ijfix.stat, > DERBY-3137-ijfix.stat, DERBY-3137-moreTests-b.diff, > DERBY-3137-moreTests-b.stat, DERBY-3137-moreTests.diff, > DERBY-3137-moreTests.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-setRoleNoDynamicNone.diff, DERBY-3137-setRoleNoDynamicNone.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.