oracleoracle-sqldeveloper
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:
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.
- How to process tabular data from Oracle PL/SQL function in JAVA?
- How do you execute SQL from within a bash script?
- How to connect to Oracle 8i using Java
- Convert JSON to table when all JSON field keys are unknown/arbitrary/random
- How to sort all numbers before letters with linguistic sorting?
- Oracle Sql Statement for unique timestamp for each row
- ambiguity error when adding pivot to existing SQL oracle statement
- Within PL/SQL script create table based on Oracle Edition
- Connect to sqlplus in a shell script and run SQL scripts
- Oracle SQL hierarchical query data accumulation
- Does Oracle field contain all letters from a string?
- Oracle JSON_TABLE to PostgreSQL - how to search from the second hierarchical key in a JSON column
- ORA-00902: invalid datatype with EF Core
- SQL query to get the employee who has not been appraised
- TOAD for Oracle, variables for schema/ table names
- ORACLE APEX ADMIN LOGIN ISSUE
- Fetch last row for each month, or previous month if not found
- How to update/add large amount of data into Oracle database from ASP.NET Core
- Convert table with columns as path (bread crumbs / levels) to hierarchy (tree) representation
- Why my query to select from Oracle database turn to text (blank query) every time i run it
- Oracle ORA-00902 Invalid datatype error
- Check if Advanced Compression is available
- Strange full table scan statements in Oracle
- Options to enforce a logical constraint in an Oracle database
- How to sort numbers before letters with linguistic sorting?
- Oracle Trigger Creation Error: PLS-00049 BAD BIND VARIABLE 'OLD'
- plsql script is raising 'ERROR at line 1 DECLARE', I don't see the reason
- Update table column based on join in Oracle
- Oracle Apex - Download CSV produces an empty report
- SSIS - the value cannot be converted because of a potential loss of data