DDL generation for table does not generate the necessary statements for the column based update privileges. I am using DS 3.1.1
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.