SQL Developer "Edit User" has incomplete DDL


I’m logged in as "SYS as SYSDBA" and am inspecting a user with SQL Developer 21.4.3. The user has some system privileges set:

But the SQL tab does not have any system privileges in the DDL:


>Solution :

Edit User…find a priv, CHECK (enable) it.

Then click on SQL page –

If you simply want to see EXISTING DDL for a USER including system privileges – open the DBA/Security panel.

Leave a ReplyCancel reply