on 11-09-2017 9:15 AM
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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).
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.