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] Commented: (DERBY-3886) SQL roles: show enabled roles
Date Mon, 29 Sep 2008 17:17:44 GMT

    [ https://issues.apache.org/jira/browse/DERBY-3886?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12635453#action_12635453
] 

Dag H. Wanvik commented on DERBY-3886:
--------------------------------------

Thanks for looking at this, Rick!

1) I was under the impression I had to provide a (dummy)
implementation of VTICosting, thank for letting me know I don't.

2) It will perhaps be good to add an ORDER BY clause to the
implementation of ij "show enabled_roles". Presently, the current role
is returned first; the rest of the rows do not have a defined order.

Another thing; the present "show role" command shows all roles defined
in the database (similar to show tables etc).  Perhaps it would be
useful to have a command to show the roles which are settable for the
session (union of those granted to the current user and to PUBLIC)?  I don't
find that information as a predefined view in the "definition schema"
of volume 11, though.

But there are many other views pertaining to roles in the definition
schema: ROLE_COLUMN_GRANTS, ROLE_ROUTINE_GRANTS, ROLE_TABLE_GRANTS,
ROLE_TABLE_METHOD_GRANTS, ROLE_USAGE_GRANTS, ROLE_UDT_GRANTS,
APPLICABLE_ROLES, and ADMINISTRABLE_ROLE_AUTHORIZATIONS, and the
*_PRIVILEGES views also consider the current role.

I am not sure I have an itch to add all of these now, but it would be nice
to get a feeling for if the approach of adding such views as VTIs is
sound. Is the schema SYSCS_DIAG ok or do we need a new one?



> 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