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] Reopened: (DERBY-3137) SQL roles: add catalog support
Date Fri, 19 Dec 2008 12:55:44 GMT

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

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


Patch DERBY-3137-setRoleNoCNF changed CURRENT_ROLE to return a SQL
identifier (no longer case normal form internal representation). This
means that the return type of VARCHAR(128) is no longer correct,
cf. SpecialFunctionNode#bindExpression, since quotes may make the
string longer than 128, even if its internal representation length is
maximum 128.

Reopening to fix this.


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


Mime
View raw message