Ok! Try this:
create user Jaime identified by jaime;
grant create session,create any table, unlimited tablespace to jaime;
Than connect as JAIME ;).
CREATE TABLE test_subpart
PARTITION BY RANGE (DATE_D)
SUBPARTITION BY LIST (MODERATORS)
PARTITION p_test VALUES LESS THAN (TO_DATE(’ 2005-02-01 00:00:00’, ‘SYYYY-MM-DD HH24:MI:SS’, ‘NLS_CALENDAR=GREGORIAN’))
SUBPARTITION P_TEST_SBR VALUES(‘BRUCE DUONG’) TABLESPACE users
Next check that enable using dba … is unchecked.
And extract DDL.
Table or view does not exist is showed in output, ddl window is showed bud cleared.
One more thing i’ve observed, but i don’t know that its not only on my sqlnav:
Afther this test, connect as dba user and execute:
revoke create session from jaime;
and then connect as Jaime.
My sqlnav shows error : Cannot open file D:!!\ORA-01045.HTML
D:!! is my default directory for sqlnav.