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 Mon, 13 Oct 2008 16:28: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:
----------------------------------


Uploading a follow-up patch to DERBY-3137-setRoleNoCNF;
DERBY-3137-setRoleNoDynamicNone, which forbids the use
of NONE as a string value to SET ROLE and adds a test.

Snipped from source comment:            

    NONE is a special case and is not allowed with its special meaning
    in SET ROLE ?. Even if there is a role with case normal form
    "NONE", we require it to be delimited here, since it would have
    had to be delimited to get created, too. We could have chosen to
    be lenient, but it seems safer to be restrictive.


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