# ORA-01031: insufficient privileges **URL:** \ **Category:** Toad for Oracle & DevOps Toolkit\ **Created:** [December 2, 2024, 4:06pm UTC](https://forums.toadworld.com/t/ora-01031-insufficient-privileges/60265 "2024-12-02T16:06:06Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![ashley.outland](https://avatars.discourse-cdn.com/v4/letter/a/bcef8e/32.png) [@ashley.outland](https://forums.toadworld.com/u/ashley.outland)\ **Post date:** [December 2, 2024, 4:06pm UTC](https://forums.toadworld.com/t/ora-01031-insufficient-privileges/60265/1 "2024-12-02T16:06:07Z")
I receive this error code when attempting to update my password to access my database. ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [December 2, 2024, 5:11pm UTC](https://forums.toadworld.com/t/ora-01031-insufficient-privileges/60265/2 "2024-12-02T17:11:57Z")
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 ---
**Author:** ![ashley.outland](https://avatars.discourse-cdn.com/v4/letter/a/bcef8e/32.png) [@ashley.outland](https://forums.toadworld.com/u/ashley.outland)\ **Post date:** [December 2, 2024, 5:39pm UTC](https://forums.toadworld.com/t/ora-01031-insufficient-privileges/60265/3 "2024-12-02T17:39:43Z")
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. ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [December 2, 2024, 5:58pm UTC](https://forums.toadworld.com/t/ora-01031-insufficient-privileges/60265/4 "2024-12-02T17:58:54Z")
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? ---
**Author:** ![ashley.outland](https://avatars.discourse-cdn.com/v4/letter/a/bcef8e/32.png) [@ashley.outland](https://forums.toadworld.com/u/ashley.outland)\ **Post date:** [December 2, 2024, 6:07pm UTC](https://forums.toadworld.com/t/ora-01031-insufficient-privileges/60265/5 "2024-12-02T18:07:46Z")
![image](https://global.discourse-cdn.com/quest/original/3X/d/2/d218d4c32eb279d36c7ae34af797fdd10bba96b9.png) 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. ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [December 2, 2024, 6:16pm UTC](https://forums.toadworld.com/t/ora-01031-insufficient-privileges/60265/6 "2024-12-02T18:16:27Z")
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? ---
**Author:** ![ashley.outland](https://avatars.discourse-cdn.com/v4/letter/a/bcef8e/32.png) [@ashley.outland](https://forums.toadworld.com/u/ashley.outland)\ **Post date:** [December 2, 2024, 6:27pm UTC](https://forums.toadworld.com/t/ora-01031-insufficient-privileges/60265/7 "2024-12-02T18:27:19Z")
Yes. I receive the same error. ![image](https://global.discourse-cdn.com/quest/original/3X/9/6/9694aa1784cc1fe4894123f91fa6de4d88121029.png) ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [December 2, 2024, 6:33pm UTC](https://forums.toadworld.com/t/ora-01031-insufficient-privileges/60265/8 "2024-12-02T18:33:34Z")
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. ---
**Author:** ![ashley.outland](https://avatars.discourse-cdn.com/v4/letter/a/bcef8e/32.png) [@ashley.outland](https://forums.toadworld.com/u/ashley.outland)\ **Post date:** [December 2, 2024, 6:45pm UTC](https://forums.toadworld.com/t/ora-01031-insufficient-privileges/60265/9 "2024-12-02T18:45:59Z")
Thank you for your assistance. I will reach out to my database administrators now.