The drag-and-drop --> DDL method of extrating DDL for an object does not generate any of the grants, as does the right-click --> DBMS Metadata method.
Can this please be added to the next release?
Thanks,
Ray
Here is an example. I extracted the DDL for the table DUAL. The table name and column name (dummy) are both in quotes is both the table definition and the grant:
CREATE TABLE "SYS"."DUAL"
( "DUMMY" VARCHAR2(1)
) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING...
Does anyone know how to turn off the double quoting of table names and column names when generating DDL for a given table? I can't find this anywhere in preferences.