DDL generation for table does not generate the necessary statements for the column based update privileges. I am using DS 3.1.1
Notice: We have upgraded developerWorks Community to the latest version of IBM Connections. For more information, read our upgrade FAQ.
Pinned topic DDL Generation omits column based privileges
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-08-30T23:52:22Z at 2012-08-30T23:52:22Z by loicjulien
Re: DDL Generation omits column based privileges2012-08-02T15:47:26ZThis is the accepted answer. This is the accepted answer.Hi,
1/ Would you mind adding the statement that you were expecting and the one that we generated. This will allow me to better understand if this is a feature gap, a defect, or if there is a way to generate what you are looking for.
2/ The use-case you used would help. For instance, were you using the "Generate DDL..." right-click context menu of the "Review and deploy changes" menu from our Change plan?
Re: DDL Generation omits column based privileges2012-08-03T08:40:56ZThis is the accepted answer. This is the accepted answer.Hi,
Sorry for the previous post. I was trying to figure out the posting problem.
I could write the ddl statements here, so I put all in the attachment.
I connect to DB2 for z/OS 10.1 CM and I create a table by the script on the left of the
Then I right click on the table and select "Generate DDL" on the Data Source Explorer view.
What i get is on the right of the attachment. No column definiton for update privilege.
Re: DDL Generation omits column based privileges2012-08-06T23:37:40ZThis is the accepted answer. This is the accepted answer.
- SystemAdmin 110000D4XK
We do have a syntax gap for the "UPDATE(column-name,...)" syntax. Before I find the best way to channel the requirement, would you mind confirming that this is what you would like Data Studio to generate?
Re: DDL Generation omits column based privileges2012-08-14T11:17:52ZThis is the accepted answer. This is the accepted answer.
- loicjulien 2700007DEB
Yes, I confirm your approach to the problem. If column-based update prvilege is given then DDL Generation should produce the output accordingly.
grant update on ... -> gives update privilege on all columns
grant update(column-name,...) -> gives update privilege on specified columns (currently Data Studio does not generate this syntax)
I wish you best of all.
Re: DDL Generation omits column based privileges2012-08-30T23:52:22ZThis is the accepted answer. This is the accepted answer.
- SystemAdmin 110000D4XK
I thank you for your answer. I apologize for the delay as I was away.
I have reported your request to product management, so that this gap can be considered for an upcoming version.
I thank you for your feedback and support.