[DERBY-3886] SQL roles: ij show enabled and settable roles

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 10.5.1.1
• Component/s: SQL, Tools
• Assignee: Dag H. Wanvik
• Reporter: Dag H. Wanvik
• Created: 26/Sep/08 19:13
• Updated: 04/May/09 18:22
• Resolved: 06/Oct/08 21:16

Description

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?

Issue Links

• is related to: DERBY-3137 SQL roles: add catalog support
• relates to: DERBY-3903 'The class 'org.apache.derby.diag.EnabledRoles' does not exist or is inaccessible.' in new roles tests (DERBY-3886)