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] Created: (DERBY-3886) SQL roles: show enabled roles
Date Fri, 26 Sep 2008 19:15:44 GMT
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.diff, enabled-roles.stat

Rick suggested it would be nice to have something to allow inspection of enabled roles, cf
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.

View raw message