Drag & Drop DDL

[hbar]

If I right-click on a table in the brower, and do either view or edit, and then view SQL, the grants are present.

But if I drag a table to an SQL window, and then choose DDL, the grants are not present.

This seems like more of a bug than a feature.

 

[Marco Kalter]

I don't know. It depends on what you see as "the DDL" of a table.

------------------
Marco Kalter
Allround Automations

 

[hbar]

I'll grant you that (no pun intended) (ok, I guess the pun was intended). But either way PL/SQL Developer defines "the DDL" in two conflicting ways depending on your method of retrieval. I would have guessed you'd use the same routine in both cases to fetch it.

 

[Marco Kalter]

It is the same routine, but it is told not to include the grants when using drag & drop. The grants are only accessible in the table definition editor.