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-3928) SQL roles: Enable the use of StatementRolePermission
Date Wed, 29 Oct 2008 12:15:44 GMT
SQL roles: Enable the use of StatementRolePermission

                 Key: DERBY-3928
                 URL: https://issues.apache.org/jira/browse/DERBY-3928
             Project: Derby
          Issue Type: Improvement
            Reporter: Dag H. Wanvik

A privilege to CREATE and DROP roles (StatementRolePermission) was
added as part of the initial roles implementation. 

The permission was added to prepare for future need to grant this
privilege. However, it is not being used for checking whether
CREATE/DROP role is allowed yet. The current code just tests if the
executing session is the database owner instead of checking that the
session has the role create/drop privilege).

Making use of the permission would not yield any new functionality,
but would prepare the way for delegating this privilege to other
users. Furthermore, there is as yet no syntax for granting or revoking
this privilege (only the database owner is supposed to enjoy it for

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message