[jira] Closed: (DERBY-3886) SQL roles: ij show enabled and settable roles

["Dag H. Wanvik (JIRA)" <ji...@apache.org>]

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

Dag H. Wanvik closed DERBY-3886.
--------------------------------

       Resolution: Fixed
    Fix Version/s: 10.5.0.0
       Derby Info:   (was: [Patch Available])

Committed as svn 702266, closing.

> SQL roles: ij show enabled and settable roles
> ---------------------------------------------
>
>                 Key: DERBY-3886
>                 URL: https://issues.apache.org/jira/browse/DERBY-3886
>             Project: Derby
>          Issue Type: Improvement
>          Components: SQL, Tools
>            Reporter: Dag H. Wanvik
>            Assignee: Dag H. Wanvik
>             Fix For: 10.5.0.0
>
>         Attachments: enabled-roles-2.diff, enabled-roles-2.stat, enabled-roles-3.diff, enabled-roles-3.stat, enabled-roles.diff, enabled-roles.stat
>
>
> Rick suggested it would be nice to have something to allow inspection of enabled roles, cf the 
> ENABLED_ROLES view of the information schema, SQL 2003, vol 11, section 5.29.
> I enclose patch suggestion for doing this via a new VTI table and syntactic sugar in ij:
> SYSCS_DIAG.ENABLED_ROLES and and ij command "show enabled_roles".
> Not for commit at this point, we may want to handle to general question of information schemata
> in another way. What say thee?

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.