[ http://issues.apache.org/jira/browse/DERBY-1643?page=all ]

Daniel John Debrunner updated DERBY-1643:
-----------------------------------------

        Summary: A  "revoke execute ... restrict" should fail if there are 
dependent objects on the execute privilege  (was: As per the functional spec 
attached to DERBY-1330, a "revoke execute ... restrict" should fail if there 
are dependent objects on the execute privilege)
    Description: 
As per the functional spec attached to DERBY-1330, a "revoke execute ... 
restrict" should fail if there are dependent objects on the execute privilege

In order to implement this, when revoke execute is executed, a special 
invalidation action should be sent and dependent objects will need to catch 
that invalidation and throw an exception. If there are no dependents, then no 
exception will be thrown and revoke execute will succeed.

I am just creating a new jira entry here so it is easier to track sub items of 
DERBY-1330. Will link this Jira entry to DERBY-1330. 

See the functional spec attached to DERBY-1330




  was:
As per the functional spec attached to DERBY-1330, a "revoke execute ... 
restrict" should fail if there are dependent objects on the execute privilege

In order to implement this, when revoke execute is executed, a special 
invalidation action should be sent and dependent objects will need to catch 
that invalidation and throw an exception. If there are no dependents, then no 
exception will be thrown and revoke execute will succeed.

I am just creating a new jira entry here so it is easier to track sub items of 
DERBY-1330. Will link this Jira entry to DERBY-1330. 







Cleaning the summary

> A  "revoke execute ... restrict" should fail if there are dependent objects 
> on the execute privilege
> ----------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-1643
>                 URL: http://issues.apache.org/jira/browse/DERBY-1643
>             Project: Derby
>          Issue Type: New Feature
>          Components: SQL
>    Affects Versions: 10.2.0.0
>            Reporter: Mamta A. Satoor
>         Assigned To: Mamta A. Satoor
>         Attachments: DERBY1643_diff_V1_RevokeExecutePrivilege.txt, 
> DERBY1643_diff_V2_RevokeExecutePrivilege.txt, 
> DERBY1643_stat_V1_RevokeExecutePrivilege.txt, 
> DERBY1643_stat_V2_RevokeExecutePrivilege.txt
>
>
> As per the functional spec attached to DERBY-1330, a "revoke execute ... 
> restrict" should fail if there are dependent objects on the execute privilege
> In order to implement this, when revoke execute is executed, a special 
> invalidation action should be sent and dependent objects will need to catch 
> that invalidation and throw an exception. If there are no dependents, then no 
> exception will be thrown and revoke execute will succeed.
> I am just creating a new jira entry here so it is easier to track sub items 
> of DERBY-1330. Will link this Jira entry to DERBY-1330. 
> See the functional spec attached to DERBY-1330

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Reply via email to