PowerDesigner can use variables in the generation and reverse-engineering of database security objects.
|
Variable |
Comment |
|---|---|
|
%PRIVLIST% |
List of privileges for a grant/revoke order |
|
%PERMLIST% |
List of permissions for a grant/revoke order |
|
%USER% |
Name of the user |
|
%GROUP% |
Name of the group |
|
%ROLE% |
Name of the role |
|
%GRANTEE% |
Generic name used to design a user, a group, or a role |
|
%PASSWORD% |
Password for a user, group, or role |
|
%OBJECT% |
Database objects (table, view, column, and so on) |
|
%GRANTOPTION% |
Option for grant: with grant option / with admin option |
|
%REVOKEOPTION% |
Option for revoke: with cascade |