db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rick Hillegas (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-3886) SQL roles: show enabled roles
Date Thu, 02 Oct 2008 18:23:44 GMT

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

Rick Hillegas commented on DERBY-3886:
--------------------------------------

Hi Dag. What's the difference between the SQL in the patch:

select roleid from sys.sysroles s, (values current_user) c(usr)
where s.grantee = c.usr or s.grantee = 'PUBLIC'

and the following query:

select roleid from sys.sysroles s
where s.grantee = current_user or s.grantee = 'PUBLIC'

Thanks!

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


Mime
View raw message