Export User DDL

[poei]

I am trying to find a way to export the DDL for a couple of users. I can do it by viewing the user and view the sql, but I would like to select a couple of users and save it to a sql file.

Is there any way I can do this in the current version ?

 

[Marco Kalter]

Yes. Open a Command Window or SQL Window, select the users in the Object Browser (Ctrl-Click or Shift-Click for multi-select), drag them to the editor of the window, and select "DDL" after dropping them in the editor.

 

[poei]

Great Stuff,

This will do thanx.