{"id":251,"date":"2024-12-17T03:28:40","date_gmt":"2024-12-17T03:28:40","guid":{"rendered":"https:\/\/w3buddy.com\/?p=251"},"modified":"2026-01-15T13:12:13","modified_gmt":"2026-01-15T07:42:13","slug":"how-to-find-when-a-users-password-was-last-changed-in-oracle","status":"publish","type":"post","link":"https:\/\/w3buddy.com\/blog\/how-to-find-when-a-users-password-was-last-changed-in-oracle\/","title":{"rendered":"How to Find When a User&#8217;s Password Was Last Changed in Oracle"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Someone reported a login error:<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-sql\">ORA-01017: invalid username\/password; logon denied<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">If you suspect a password change has occurred without notification, you can quickly verify the last password change datetime in Oracle using the following query:<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-sql\">SELECT PASSWORD_CHANGE_DATE\u00a0 \nFROM DBA_USERS\u00a0 \nWHERE USERNAME = 'W3BUDDY';<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Output Example:<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-sql\">PASSWORD_CHANGE_DATE\u00a0 \n--------------------\u00a0 \n2024-06-17 11:34:52<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">This confirms the exact date and time the password for user W3BUDDY was last modified. Ensure you have sufficient privileges to query the DBA_USERS view.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Also read this:<\/h2>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-w-3-buddy wp-block-embed-w-3-buddy\"><div class=\"wp-block-embed__wrapper\">\nhttps:\/\/w3buddy.com\/blog\/oracle-user-management-complete-guide\/\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Someone reported a login error: If you suspect a password change has occurred without notification, you can quickly verify the last password change datetime in Oracle using the following query: Output Example: This confirms the exact date and time the password for user W3BUDDY was last modified. Ensure you have sufficient privileges to query the [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"googlesitekit_rrm_CAowu461DA:productID":"","footnotes":""},"categories":[1225],"tags":[],"class_list":["post-251","post","type-post","status-publish","format-standard","hentry","category-database"],"_links":{"self":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/posts\/251","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/comments?post=251"}],"version-history":[{"count":8,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/posts\/251\/revisions"}],"predecessor-version":[{"id":1467,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/posts\/251\/revisions\/1467"}],"wp:attachment":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/media?parent=251"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/categories?post=251"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/tags?post=251"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}