# Extract DDL and Generate SQL Create not including DB2 z/OS role privileges

**URL:** <https://forums.toadworld.com/t/extract-ddl-and-generate-sql-create-not-including-db2-z-os-role-privileges/58293>\
**Category:** Toad for IBM DB2\
**Created:** [October 10, 2023, 5:15pm UTC](https://forums.toadworld.com/t/extract-ddl-and-generate-sql-create-not-including-db2-z-os-role-privileges/58293 "2023-10-10T17:15:14Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![dtaylor01](https://avatars.discourse-cdn.com/v4/letter/d/f475e1/32.png) [@dtaylor01](https://forums.toadworld.com/u/dtaylor01)\
**Post date:** [October 10, 2023, 5:15pm UTC](https://forums.toadworld.com/t/extract-ddl-and-generate-sql-create-not-including-db2-z-os-role-privileges/58293/1 "2023-10-10T17:15:14Z")

</div>

When doing an Extract DDL with the Include Privileges option specified, we are not seeing the grants for Roles being returned in the DDL script. We also noticed that they don't show up when selecting the Generate SQL, Create Script option. If I view the details of an object and go to the Grants tab, I can see the roles listed there. Could we get an enhancement to include Roles when doing the Extract DDL with Include Privileges and also for the Create Script options?

![image](https://global.discourse-cdn.com/quest/original/3X/8/3/83fe2d5c11cc04e5a85c178c8f8615c76dabba45.png)

We are currently using Toad for IBM DB2: version 7.4.0.79.

---

<div class="post-metadata">

**Author:** ![dtaylor01](https://avatars.discourse-cdn.com/v4/letter/d/f475e1/32.png) [@dtaylor01](https://forums.toadworld.com/u/dtaylor01)\
**Post date:** [October 26, 2023, 5:36pm UTC](https://forums.toadworld.com/t/extract-ddl-and-generate-sql-create-not-including-db2-z-os-role-privileges/58293/2 "2023-10-26T17:36:12Z")

</div>

Just wanted to do a follow-up on this topic. This issue was sent to the support team, but I was directed to instead post it here in the forum. Is there something else I need to do in order to get this bug reviewed?

---

<div class="post-metadata">

**Author:** ![Gita.Sharifi](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/gita.sharifi/32/16973_2.png) [@Gita.Sharifi](https://forums.toadworld.com/u/Gita.Sharifi)\
**Post date:** [October 26, 2023, 7:49pm UTC](https://forums.toadworld.com/t/extract-ddl-and-generate-sql-create-not-including-db2-z-os-role-privileges/58293/3 "2023-10-26T19:49:50Z")

</div>

Hi,  
We've logged the issue in our tracking system as ID # TDB-4146. We'll have the development investigate the issue for a possible fix in the next release of Toad - v8.0. Thanks for reporting it to us.