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] Commented: (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 Thu, 27 Jul 2006 02:49:14 GMT
    [ http://issues.apache.org/jira/browse/DERBY-1543?page=comments#action_12423757 ] 
            
Satheesh Bandaram commented on DERBY-1543:
------------------------------------------

What is the failure you are seeing with synonyms? Attempting to GRANT or REVOKE privileges
to synonyms should fail. Synonyms are supposed to be used only in DML statements and not DDL
statements. For example, attempting to create an index on synonym, expecting an index to be
created on target of the synonym, should fail with error. However, DML statements are supposed
to resolve synonyms to their target tables or views.



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