SQL Developer "Edit User" has incomplete DDL

Advertisements

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:

Why?

>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