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 Mon, 24 Jul 2006 06:59:15 GMT
     [ http://issues.apache.org/jira/browse/DERBY-1543?page=all ]

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

    Attachment: DERBY-1543.out

This (temp) patch addresses both these remaining issues. Some work is needed to complete this
patch... including 1) Extending droping of descriptors to cover routine perms. Covers Table
and Column permission descriptors for now 2) Adding test cases 3) Improve warning mechanism.

Any thoughts on when the Warning should be raised if authorization is ON without authentication?
Should it be on every new connection creation or only at the boot time? Is there a concern
that raising this warning might actually alert users about lack of authentication?

I will submit complete patch in a day or two.
   

> 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
>             Fix For: 10.2.0.0
>
>         Attachments: DERBY-1543.out
>
>
> 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