db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Satheesh Bandaram (JIRA)" <derby-...@db.apache.org>
Subject [jira] Updated: (DERBY-1543) Address two remaining issues with GRANT/REVOKE functionality: 1) Add warning when sqlAuthorization is on with authentication off 2) Drop permission descriptors when objects they cover are dropped.
Date Fri, 28 Jul 2006 17:57:14 GMT
     [ http://issues.apache.org/jira/browse/DERBY-1543?page=all ]

Satheesh Bandaram updated DERBY-1543:
-------------------------------------

    Attachment: Derby1543.diff

This patch should address these two left over items in GRANT/REVOKE implementation. Some implementation
notes:

1) Now Derby raises an SQLWarning when SQL authorization is ON without authentication at connect
time. This is done by checking if AuthenticationService being used is an instance of NoneAuthenticationServiceImpl.
Since this is the default authentication service with Derby, it should always be present.

2) Added code to drop permission descriptors from SYSTABLEPERMS, SYSCOLPERMS and SYSROUTINEPERMS
when the object they provide permission for is dropped. This includes tables, views and routines
and these descriptors needs to be removed from permissionCache as well.

I have tested the cases when PermissionsDescriptors are in cache also.

Passed GrantRevoke tests. Will run derbyAll tonight and submit changes over the weekend.


> Address two remaining issues with GRANT/REVOKE functionality: 1) Add warning when sqlAuthorization
is on with authentication off 2) Drop permission descriptors when objects they cover are dropped.
> ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-1543
>                 URL: http://issues.apache.org/jira/browse/DERBY-1543
>             Project: Derby
>          Issue Type: Sub-task
>          Components: SQL
>    Affects Versions: 10.2.0.0
>            Reporter: Satheesh Bandaram
>         Assigned To: Satheesh Bandaram
>             Fix For: 10.2.0.0
>
>         Attachments: DERBY-1543.out, Derby1543.diff
>
>
> Address two remaining sub-tasks:
> Add warning when sqlAuthorization is on with authentication off: This is a precautionary
warning, since sqlAuthorization doesn't mean much without authentication being ON.
> Drop permission descriptors when objects they cover are dropped: This applies to tables,
routines. When these objects are dropped, automatically drop their permisson descriptors.

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

        

Mime
View raw message