Is your feature request related to a problem? Please describe.
We need to be able to generate the DDL for an Oracle User. Other products will generate on schema, but dbeaver schema ddl generation does all objects under it and all we require is the user portion of it.
Describe the solution you'd like
Under the Security->Users tree node, we would like a Generate SQL->DDL option for users. The output should be similar to the out generated by these 4 statements.
SELECT DBMS_METADATA.GET_DDL('USER','USERNAME') FROM dual;
SELECT DBMS_METADATA.GET_GRANTED_DDL('ROLE_GRANT', 'USERNAME') FROM dual;
SELECT DBMS_METADATA.GET_GRANTED_DDL('SYSTEM_GRANT', 'USERNAME') FROM dual;
SELECT DBMS_METADATA.GET_GRANTED_DDL('OBJECT_GRANT', 'USERNAME') FROM dual;
Describe alternatives you've considered
We would need to run sql statements manually to generate the needed text for complete DDL.
Additional context
Add any other context or screenshots about the feature request here.
Is your feature request related to a problem? Please describe. We need to be able to generate the DDL for an Oracle User. Other products will generate on schema, but dbeaver schema ddl generation does all objects under it and all we require is the user portion of it.
Describe the solution you'd like Under the Security->Users tree node, we would like a Generate SQL->DDL option for users. The output should be similar to the out generated by these 4 statements.
SELECT DBMS_METADATA.GET_DDL('USER','USERNAME') FROM dual; SELECT DBMS_METADATA.GET_GRANTED_DDL('ROLE_GRANT', 'USERNAME') FROM dual; SELECT DBMS_METADATA.GET_GRANTED_DDL('SYSTEM_GRANT', 'USERNAME') FROM dual; SELECT DBMS_METADATA.GET_GRANTED_DDL('OBJECT_GRANT', 'USERNAME') FROM dual;
Describe alternatives you've considered We would need to run sql statements manually to generate the needed text for complete DDL.
Additional context Add any other context or screenshots about the feature request here.