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


Mime
View raw message