[jira] Updated: (DERBY-3886) SQL roles: show enabled 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 updated DERBY-3886:
---------------------------------

    Attachment: enabled-roles-2.stat
                enabled-roles-2.diff

Uploading version 2 of this patch which:

- took Rick's two suggestions
- added "show settable_roles" command to ij (impl. as a SQL query)
- modified the tools/ij_show_roles script by spitting it into
  two: ij_show_roles_dbo and ij_show_roles_usr to
  be able to test the settable_roles (which typically differ for the data base
  owner and an ordinary db user)
- added help text for the ij roles show commands

Regressions ran ok. 

> SQL roles: show enabled 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
>         Attachments: enabled-roles-2.diff, enabled-roles-2.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.