I've logged this to be addressed in a future version.
In the meantime, you could:
- create a snippet to perform this operation
- use the existing dialog and copy out the SQL to the worksheet and modify/run from there
Thanks, Jeff. that is exactly the answer I was looking for. I did submit a Feature request through the APEX page yesterday as well. I just wanted to make sure I wasn't missing an area on Oracle SQL developer that may have had this functionality through the UI.
In v4 I can actually change up the SQL in the Create User panel, and that is executed as-is if I hit apply.
And as I mentioned I can do the same in 220.127.116.11 (I just tested again using the steps I posted) so if TSharma can't do it in 10 there may have been an issue that the new version addresses.