I receive this error code when attempting to update my password to access my database.
I just tested this with a user that has only the CREATE SESSION privilege and was unable to reproduce it.
Try turning on spool SQL to see if you can see the SQL that Toad is running which you don't have privs to run.
Database -> Spool SQL -> Spool to screen.
-John
This error occurs prior to the logging into the database or entering the workspace for Toad. The error appears when I have input my new password twice. This stops me from updating the password that will expire in 3 days.
oh, ok. I just set this up on Toad version 2024.2 and was still unable to get that error (with the least-privileged user I could think of).
Which Toad version are you on?
Can you turn on spool SQL and see if you can identify a SQL that is causing the error?
In case the attached image can't be seen, my version is 2004 R2 (24.2.275.4664)
When I open the Spool SQL it doesn't show anything after I have logged in with my current password.
if you go into the editor run the following with F9:
ALTER USER my_user_name IDENTIFIED BY my_new_password;
(swapping in appropriate values, of course)
Do you get the error there too?
Ok, then you should talk to your database administrator. This is not a Toad issue, it's a database or privilege issue.
I don't think you should be getting this error just for attempting to change your own password. I think there is something else at play here.
Thank you for your assistance. I will reach out to my database administrators now.