However, after seeing this raised, it seems clear to me that taken in combination, its confusing. This works with any driver.Įither one of these ways of changing your password makes sense on its own.
The 'password' command will bring up a dialog to prompt you for your old password and new password, and then execute the SQL for you. However, maybe you don't want your password typed in the clear in the worksheet (and possibly saved off to your command history). This is actually quite straightforward - the 'ALTER USER' SQL statement will take care of this for you. The second use case is that you have connected to the database and you wish to change your password.
#Custom restart option greyed out driver#
If the OCI driver isn't available, then the menu item is disabled. This is the service we provide via the context menu on a connection, and this is what requires the presence of the OCI driver. You provide the old and new passwords and it updates it. However, the OCI (Thick) driver provides a means for performing a reset of your password. In this case, you cannot connect to the database to change your password. The first use case is when your password has aged out and you are thus locked out of the database. Just to chime in here, SQL Developer supports two different use-cases for changing your password and thus has two different ways to do it.
0 kommentar(er)
