[jira] [Updated] (TRAFODION-12) Grant revoke enhancements

["Suresh Subbiah (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/TRAFODION-12?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Suresh Subbiah updated TRAFODION-12:
------------------------------------
    Component/s: sql-security

> 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.4#6332)