You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "David Wayne Birdsall (JIRA)" <ji...@apache.org> on 2017/05/02 19:20:04 UTC
[jira] [Updated] (TRAFODION-2603) Remove obsolete utility commands,
turn off obsolete privileges
[ https://issues.apache.org/jira/browse/TRAFODION-2603?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
David Wayne Birdsall updated TRAFODION-2603:
--------------------------------------------
Description:
The PUBLISH and UNPUBLISH commands were a feature in the predecessor product and do not work in Trafodion. The specific need for them does not exist in Trafodion, so these can be removed.
The INITIALIZE TRAFODION, CREATE SEQUENCE utility was used to create the SEQ_GEN table in the metadata to support sequences. That table is now created as part of INITIALIZE TRAFODION, so there is no longer a need for the CREATE SEQUENCE option. It can be removed.
The DML_* component privileges allow the Root ID to grant various DML privileges to any user, giving them the ability to do a given DML operation on any Trafodion object. They don't work at the present. And the wisdom of having such component privileges is debatable. For now, we would like to add code that simply raises an error and says these privileges are not supported if an attempt is made to grant them.
was:
The PUBLISH and UNPUBLISH commands were a feature in the predecessor product and do not work in Trafodion. The specific need for them does not exist in Trafodion, so these can be removed.
The INITIALIZE TRAFODION, CREATE SEQUENCE utility was used to create the SEQ_GEN table in the metadata to support sequences. That table is now created as part of INITIALIZE TRAFODION, so there is no longer a need for it. It can be removed.
The DML_* component privileges allow the Root ID to grant various DML privileges to any user, giving them the ability to do a given DML operation on any Trafodion object. They don't work at the present. And the wisdom of having such component privileges is debatable. For now, we would like to add code that simply raises an error and says these privileges are not supported if an attempt is made to grant them.
> Remove obsolete utility commands, turn off obsolete privileges
> --------------------------------------------------------------
>
> Key: TRAFODION-2603
> URL: https://issues.apache.org/jira/browse/TRAFODION-2603
> Project: Apache Trafodion
> Issue Type: Improvement
> Components: sql-cmp
> Affects Versions: 2.2-incubating
> Environment: All
> Reporter: David Wayne Birdsall
> Assignee: David Wayne Birdsall
>
> The PUBLISH and UNPUBLISH commands were a feature in the predecessor product and do not work in Trafodion. The specific need for them does not exist in Trafodion, so these can be removed.
> The INITIALIZE TRAFODION, CREATE SEQUENCE utility was used to create the SEQ_GEN table in the metadata to support sequences. That table is now created as part of INITIALIZE TRAFODION, so there is no longer a need for the CREATE SEQUENCE option. It can be removed.
> The DML_* component privileges allow the Root ID to grant various DML privileges to any user, giving them the ability to do a given DML operation on any Trafodion object. They don't work at the present. And the wisdom of having such component privileges is debatable. For now, we would like to add code that simply raises an error and says these privileges are not supported if an attempt is made to grant them.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)