[
https://issues.apache.org/jira/browse/TRAFODION-12?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Roberta Marton closed TRAFODION-12.
-----------------------------------
Resolution: Fixed
> Grant revoke enhancements
> -------------------------
>
> Key: TRAFODION-12
> URL: https://issues.apache.org/jira/browse/TRAFODION-12
> Project: Apache Trafodion
> Issue Type: Improvement
> Components: sql-security
> Reporter: Roberta Marton
> Assignee: Roberta Marton
> Labels: security
> Original Estimate: 672h
> Remaining Estimate: 672h
>
> This JIRA covers improvements related to Trafodion grant and revoke commands.
> At the time Trafodion became part of Apache, part of this work was
> completed. The remaining work is covered by this JIRA.
> See http://docs.trafodion.org/privilege_manager_enhancements.pdf for a
> complete description of these improvements.
> Grant/Revoke enhancements include:
> Column-level privileges for tables and views - mostly completed, work
> remaining includes:
> - REVOKE ROLE RESTRICT does not consider column privileges.
> - REVOKE RESTRICT for columns is only partially tested, catman1/TEST129 has
> been added but is incomplete
> Support for WITH GRANT OPTION and GRANT OPTION FOR clauses for object-level
> and column-level GRANT and REVOKE statements - this work is complete and
> tests exists in catman1/TEST140.
>
> Support for GRANTED BY clause for object-level and column-level GRANT and
> REVOKE statements - - this work is complete and tests exists in
> catman1/TEST140.
> CASCADE support for all REVOKE commands - work has not been started.
> Support a grantee list for object-level and column-level GRANT and REVOKE
> statements - work has not been started.
> New component-level privileges - work is in progress
> New Privilege Manager metadata tables and support for upgrade to the new and
> changed metadata - work has been committed but is part of the overall upgrade
> operation
> Addition and modification of showddl and get commands to provide information
> on Privilege Manager metadata - work has not been started
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
