SQL Developer "Edit User" has incomplete DDL-CodePudding

Home > Software design > SQL Developer "Edit User" has incomplete DDL

SQL Developer "Edit User" has incomplete DDL

Time：05-25

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?

CodePudding user response：

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.