Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Message-ID: <18759090.1153968554777.JavaMail.jira@brutus>
Date: Wed, 26 Jul 2006 19:49:14 -0700 (PDT)
From: "Satheesh Bandaram (JIRA)" <derby-dev@db.apache.org>
To: derby-dev@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.
In-Reply-To: <28664278.1153355953905.JavaMail.jira@brutus>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

    [ 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