[ http://issues.apache.org/jira/browse/DERBY-1543?page=comments#action_12423772 ] Yip Ng commented on DERBY-1543: -------------------------------
Are you referring in the context of Derby? For example, DB2 and IDS allows synonyms in their GRANT or REVOKE statements. db2 => create table t1 (c1 int) DB20000I The SQL command completed successfully. db2 => create synonym s1 for t1 DB20000I The SQL command completed successfully. db2 => grant select on s1 to user2 DB20000I The SQL command completed successfully. db2 => revoke select on s1 from user2 DB20000I The SQL command completed successfully. db2=> > 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
