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