Generating DDL

dbForge Studio for Oracle allows you to view DDL statements for users, roles and profiles. To view DDL statements, you should:

  1. Open Security Manager.
  2. Expand the required node (Users, Roles or Profiles).
  3. Right-click the required user, role or profile.
  4. Select Generate Schema Script on the shortcut menu.