cancel
Showing results for 
Search instead for 
Did you mean: 

Power designer 16.6 - Generate ddl

pave
Discoverer
0 Kudos

When I want to generate DDL scripts in power designer (out of the PDM), and I want to create the grants for a specific table, then the granteetype is not in my ddl script. I have been looking in the "edit current DBMS" options for my permissions, and this is the value:

grant %PERMLIST% on [%R%?%@CLSSNAME%:%className% ][%QUALIFIER%]%OBJECT% to %GRANTEE% [%GRANTOPTION%]

Is there any value or field that I can insert here to add the keyword USER or GROUP (depending on whether it are permissions for a group or user.

Accepted Solutions (1)

Accepted Solutions (1)

former_member200945
Contributor
0 Kudos

Start Powerdesigner. Open the PDM. Go to Database->Generate Database.

Click Options tab. Check Permission under Table.

If you assign a user to a table and assign some permissions to the user, this is the output:

pave
Discoverer
0 Kudos

Thank you for that answer. Unfortunately it does not get me the solution, because I wanted to have the keyword USER or GROUP. But I also found out that this is not necessary. If the user or the group exists in db2, it will take the correct one, and plus: a user and a group in db2 cannot have the same name. If you specify a user or group in the script that does not exist in db2, then db2 will automatically create a user with that name in db2, but that user cannot be used, since the user (and password) does not exist on the Linux machine (we use dB2 for luw on a Linux Suse machine, in fact, a partition on our z/VSE mainframe).

Answers (0)