{"id":225,"date":"2011-11-21T15:39:44","date_gmt":"2011-11-21T12:39:44","guid":{"rendered":"http:\/\/fatihacar.com\/blog\/?p=225"},"modified":"2011-11-21T15:42:43","modified_gmt":"2011-11-21T12:42:43","slug":"alter-profile-in-oracle","status":"publish","type":"post","link":"http:\/\/www.fatihacar.com\/blog\/alter-profile-in-oracle\/","title":{"rendered":"Alter Profile in Oracle"},"content":{"rendered":"<p>If you want to change profile parameters, you have to use alter command. Default User Life Time coming limited as 180 in Oracle 11g. You can change of this limit. Because this parameter cause of expired password. If you do not want to expired password, You have to change this parameter.<\/p>\n<p><strong>Show Profile Parameters<\/strong><\/p>\n<blockquote><p>\nSQL> SELECT profile, resource_name, limit FROM dba_profiles WHERE profile=&#8217;DEFAULT&#8217;;\n<\/p><\/blockquote>\n<p><strong>Change Profile Parameters<\/strong><\/p>\n<blockquote><p>\nSQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME 60;<\/p>\n<p>or<\/p>\n<p>SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;\n<\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"<p>If you want to change profile parameters, you have to use alter command. Default User Life Time coming limited as 180 in Oracle 11g. You can change of this limit. Because this parameter cause of expired password. If you do not want to expired password, You have to change this parameter. Show Profile Parameters SQL>&#8230;<\/p>\n","protected":false},"author":37,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[9],"tags":[14,90],"class_list":["post-225","post","type-post","status-publish","format-standard","hentry","category-administration","tag-database-administration","tag-oracle"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p39NFI-3D","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/225","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/users\/37"}],"replies":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/comments?post=225"}],"version-history":[{"count":4,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/225\/revisions"}],"predecessor-version":[{"id":229,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/225\/revisions\/229"}],"wp:attachment":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/media?parent=225"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/categories?post=225"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/tags?post=225"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}