{"id":15388,"date":"2020-12-10T12:14:39","date_gmt":"2020-12-10T11:14:39","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/oracle-21c-security-gradual-database-password-rollover\/"},"modified":"2023-06-20T10:11:08","modified_gmt":"2023-06-20T08:11:08","slug":"oracle-21c-security-gradual-database-password-rollover","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/oracle-21c-security-gradual-database-password-rollover\/","title":{"rendered":"Oracle 21c Security : Gradual Database Password Rollover"},"content":{"rendered":"

By Mouhamadou Diaw<\/strong><\/p>\n

Starting with Oracle 21c, a password of an application can be changed without having to schedule a downtime. This can be done by using the new profile parameter PASSWORD_ROLLOVER_TIME
\nThis will set a rollover period of time where the application can log in using either the old password or the new password. With this enhancement, an administrator does not need any more to take the application down when the application database password is being rotated.
\nLet see in this blog how this works<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n<\/td>\n
\n
\n
SQL> show pdbs<\/code><\/div>\n
<\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>CON_ID CON_NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/code>OPEN<\/code> MODE\u00a0 RESTRICTED<\/code><\/div>\n
---------- ------------------------------ ---------- ----------<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>2 PDB$SEED\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/code>READ<\/code> ONLY<\/code>\u00a0 NO<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>3 PDB1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/code>READ<\/code> WRITE <\/code>NO<\/code><\/div>\n
SQL><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

First we create a profile in PDB1<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n<\/td>\n
\n
\n
SQL> show con_name;<\/code><\/div>\n
<\/div>\n
CON_NAME<\/code><\/div>\n
------------------------------<\/code><\/div>\n
PDB1<\/code><\/div>\n
<\/div>\n
<\/div>\n
SQL> <\/code>CREATE<\/code> PROFILE testgradualrollover LIMIT<\/code><\/div>\n
\u00a0<\/code>FAILED_LOGIN_ATTEMPTS 4<\/code><\/div>\n
\u00a0<\/code>PASSWORD_ROLLOVER_TIME 4;\u00a0 <\/code><\/div>\n
<\/div>\n
Profile created.<\/code><\/div>\n
<\/div>\n
SQL><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Note that the parameter PASSWORD_ROLLOVER_TIME is specified in days. For example, 1\/24 means 1H.
\nThe minimum value for this parameter is 1h and the maximum value is 60 days or the lower value of the PASSWORD_LIFE_TIME or PASSWORD_GRACE_TIME parameter.
\nNow let\u2019s create a new user in PDB1 and let\u2019s assign him the profile we created<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n<\/td>\n
\n
\n
SQL> <\/code>create<\/code> user<\/code> edge identified <\/code>by<\/code> \"Borftg8957##\"<\/code>\u00a0 profile testgradualrollover;<\/code><\/div>\n
<\/div>\n
User<\/code> created.<\/code><\/div>\n
<\/div>\n
SQL> <\/code>grant<\/code> create<\/code> session <\/code>to<\/code> edge;<\/code><\/div>\n
<\/div>\n
Grant<\/code> succeeded.<\/code><\/div>\n
<\/div>\n
SQL><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

We can also verify the status of the account in the PDB<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n<\/td>\n
\n
\n
SQL>\u00a0 <\/code>select<\/code> username,account_status <\/code>from<\/code> dba_users <\/code>where<\/code> username=<\/code>'EDGE'<\/code>;<\/code><\/div>\n
<\/div>\n
USERNAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ACCOUNT_STATUS<\/code><\/div>\n
-------------------- --------------------<\/code><\/div>\n
EDGE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/code>OPEN<\/code><\/div>\n
<\/div>\n
SQL><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Now let\u2019s log with new user<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n<\/td>\n
\n
\n
[oracle@oraadserver admin]$ sqlplus edge\/<\/code>\"Borftg8957##\"<\/code>@pdb1<\/code><\/div>\n
<\/div>\n
SQL*Plus: Release 21.0.0.0.0 - Production <\/code>on<\/code> Thu <\/code>Dec<\/code> 10 11:14:07 2020<\/code><\/div>\n
Version 21.1.0.0.0<\/code><\/div>\n
<\/div>\n
Copyright (c) 1982, 2020, Oracle.\u00a0 <\/code>All<\/code> rights reserved.<\/code><\/div>\n
<\/div>\n
<\/div>\n
Connected <\/code>to<\/code>:<\/code><\/div>\n
Oracle <\/code>Database<\/code> 21c Enterprise Edition Release 21.0.0.0.0 - Production<\/code><\/div>\n
Version 21.1.0.0.0<\/code><\/div>\n
<\/div>\n
SQL> show con_name;<\/code><\/div>\n
<\/div>\n
CON_NAME<\/code><\/div>\n
------------------------------<\/code><\/div>\n
PDB1<\/code><\/div>\n
SQL> show <\/code>user<\/code>;<\/code><\/div>\n
USER<\/code> is<\/code> \"EDGE\"<\/code><\/div>\n
SQL><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Now let\u2019s change the password of the user edge<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n<\/td>\n
\n
\n
SQL> <\/code>alter<\/code> user<\/code> edge identified <\/code>by<\/code> \"Morfgt5879!!\"<\/code>;<\/code><\/div>\n
<\/div>\n
User<\/code> altered.<\/code><\/div>\n
<\/div>\n
SQL><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

As the rollover period is set to 4 days in the profile testgradualrollover, the user edge should be able to connect during 4 days with either the old password or the new one.
\nLet\u2019s test with the old password<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n<\/td>\n
\n
\n
[oracle@oraadserver admin]$ sqlplus edge\/<\/code>\"Borftg8957##\"<\/code>@pdb1<\/code><\/div>\n
<\/div>\n
SQL*Plus: Release 21.0.0.0.0 - Production <\/code>on<\/code> Thu <\/code>Dec<\/code> 10 11:21:02 2020<\/code><\/div>\n
Version 21.1.0.0.0<\/code><\/div>\n
<\/div>\n
Copyright (c) 1982, 2020, Oracle.\u00a0 <\/code>All<\/code> rights reserved.<\/code><\/div>\n
<\/div>\n
Last<\/code> Successful login <\/code>time<\/code>: Thu <\/code>Dec<\/code> 10 2020 11:14:07 +01:00<\/code><\/div>\n
<\/div>\n
Connected <\/code>to<\/code>:<\/code><\/div>\n
Oracle <\/code>Database<\/code> 21c Enterprise Edition Release 21.0.0.0.0 - Production<\/code><\/div>\n
Version 21.1.0.0.0<\/code><\/div>\n
<\/div>\n
SQL> show con_name;<\/code><\/div>\n
<\/div>\n
CON_NAME<\/code><\/div>\n
------------------------------<\/code><\/div>\n
PDB1<\/code><\/div>\n
SQL> show <\/code>user<\/code>;<\/code><\/div>\n
USER<\/code> is<\/code> \"EDGE\"<\/code><\/div>\n
SQL><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Let\u2019s test with the new password<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n
22<\/div>\n<\/td>\n
\n
\n
[oracle@oraadserver ~]$ sqlplus edge\/<\/code>'Morfgt5879!!'<\/code>@pdb1<\/code><\/div>\n
<\/div>\n
SQL*Plus: Release 21.0.0.0.0 - Production <\/code>on<\/code> Thu <\/code>Dec<\/code> 10 11:24:52 2020<\/code><\/div>\n
Version 21.1.0.0.0<\/code><\/div>\n
<\/div>\n
Copyright (c) 1982, 2020, Oracle.\u00a0 <\/code>All<\/code> rights reserved.<\/code><\/div>\n
<\/div>\n
Last<\/code> Successful login <\/code>time<\/code>: Thu <\/code>Dec<\/code> 10 2020 11:21:02 +01:00<\/code><\/div>\n
<\/div>\n
Connected <\/code>to<\/code>:<\/code><\/div>\n
Oracle <\/code>Database<\/code> 21c Enterprise Edition Release 21.0.0.0.0 - Production<\/code><\/div>\n
Version 21.1.0.0.0<\/code><\/div>\n
<\/div>\n
SQL> show <\/code>user<\/code>;<\/code><\/div>\n
USER<\/code> is<\/code> \"EDGE\"<\/code><\/div>\n
<\/div>\n
SQL> show con_name;<\/code><\/div>\n
<\/div>\n
CON_NAME<\/code><\/div>\n
------------------------------<\/code><\/div>\n
PDB1<\/code><\/div>\n
SQL><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

We can see that the connection is successfully done with both cases. If we query the dba_users we can see the status of the rollover<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n<\/td>\n
\n
\n
SQL> <\/code>select<\/code> username,account_status <\/code>from<\/code> dba_users <\/code>where<\/code> username=<\/code>'EDGE'<\/code>;<\/code><\/div>\n
<\/div>\n
USERNAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ACCOUNT_STATUS<\/code><\/div>\n
-------------------- --------------------<\/code><\/div>\n
EDGE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/code>OPEN<\/code> & <\/code>IN<\/code> ROLLOVER<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

To end the password rollover period
\n-Let the password rollover expire on its own
\n-As either the user or an administrator run the command<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n<\/td>\n
\n
\n
Alter<\/code> user<\/code> edge expire <\/code>password<\/code> rollover period;<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

-As an administrator, expire the user password<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n<\/td>\n
\n
\n
Alter<\/code> user<\/code> edge <\/code>password<\/code> expire;<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Database behavior during the gradual password rollover period can be found here<\/a> in the documentation<\/p>\n","protected":false},"excerpt":{"rendered":"

By Mouhamadou Diaw Starting with Oracle 21c, a password of an application can be changed without having to schedule a downtime. This can be done by using the new profile parameter PASSWORD_ROLLOVER_TIME This will set a rollover period of time where the application can log in using either the old password or the new password. […]<\/p>\n","protected":false},"author":27,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229,198,59,149],"tags":[2208,137,2209,2210,25],"type_dbi":[],"class_list":["post-15388","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","category-database-management","category-oracle","category-security","tag-gradual-password-rollover","tag-oracle-21c","tag-oracle-profile","tag-password-lifetime","tag-security"],"acf":[],"yoast_head":"\nOracle 21c Security : Gradual Database Password Rollover - dbi Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/oracle-21c-security-gradual-database-password-rollover\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle 21c Security : Gradual Database Password Rollover\" \/>\n<meta property=\"og:description\" content=\"By Mouhamadou Diaw Starting with Oracle 21c, a password of an application can be changed without having to schedule a downtime. This can be done by using the new profile parameter PASSWORD_ROLLOVER_TIME This will set a rollover period of time where the application can log in using either the old password or the new password. […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/oracle-21c-security-gradual-database-password-rollover\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2020-12-10T11:14:39+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-06-20T08:11:08+00:00\" \/>\n<meta name=\"author\" content=\"Oracle Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Oracle Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-21c-security-gradual-database-password-rollover\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-21c-security-gradual-database-password-rollover\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"Oracle 21c Security : Gradual Database Password Rollover\",\"datePublished\":\"2020-12-10T11:14:39+00:00\",\"dateModified\":\"2023-06-20T08:11:08+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-21c-security-gradual-database-password-rollover\/\"},\"wordCount\":309,\"commentCount\":0,\"keywords\":[\"gradual password rollover\",\"Oracle 21C\",\"oracle profile\",\"password lifetime\",\"Security\"],\"articleSection\":[\"Database Administration & Monitoring\",\"Database management\",\"Oracle\",\"Security\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oracle-21c-security-gradual-database-password-rollover\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-21c-security-gradual-database-password-rollover\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/oracle-21c-security-gradual-database-password-rollover\/\",\"name\":\"Oracle 21c Security : Gradual Database Password Rollover - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2020-12-10T11:14:39+00:00\",\"dateModified\":\"2023-06-20T08:11:08+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-21c-security-gradual-database-password-rollover\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oracle-21c-security-gradual-database-password-rollover\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-21c-security-gradual-database-password-rollover\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle 21c Security : Gradual Database Password Rollover\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\",\"name\":\"Oracle Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"caption\":\"Oracle Team\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Oracle 21c Security : Gradual Database Password Rollover - dbi Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/oracle-21c-security-gradual-database-password-rollover\/","og_locale":"en_US","og_type":"article","og_title":"Oracle 21c Security : Gradual Database Password Rollover","og_description":"By Mouhamadou Diaw Starting with Oracle 21c, a password of an application can be changed without having to schedule a downtime. This can be done by using the new profile parameter PASSWORD_ROLLOVER_TIME This will set a rollover period of time where the application can log in using either the old password or the new password. […]","og_url":"https:\/\/www.dbi-services.com\/blog\/oracle-21c-security-gradual-database-password-rollover\/","og_site_name":"dbi Blog","article_published_time":"2020-12-10T11:14:39+00:00","article_modified_time":"2023-06-20T08:11:08+00:00","author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-21c-security-gradual-database-password-rollover\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-21c-security-gradual-database-password-rollover\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"Oracle 21c Security : Gradual Database Password Rollover","datePublished":"2020-12-10T11:14:39+00:00","dateModified":"2023-06-20T08:11:08+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-21c-security-gradual-database-password-rollover\/"},"wordCount":309,"commentCount":0,"keywords":["gradual password rollover","Oracle 21C","oracle profile","password lifetime","Security"],"articleSection":["Database Administration & Monitoring","Database management","Oracle","Security"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/oracle-21c-security-gradual-database-password-rollover\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-21c-security-gradual-database-password-rollover\/","url":"https:\/\/www.dbi-services.com\/blog\/oracle-21c-security-gradual-database-password-rollover\/","name":"Oracle 21c Security : Gradual Database Password Rollover - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2020-12-10T11:14:39+00:00","dateModified":"2023-06-20T08:11:08+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-21c-security-gradual-database-password-rollover\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/oracle-21c-security-gradual-database-password-rollover\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-21c-security-gradual-database-password-rollover\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Oracle 21c Security : Gradual Database Password Rollover"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee","name":"Oracle Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","caption":"Oracle Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/15388","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=15388"}],"version-history":[{"count":1,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/15388\/revisions"}],"predecessor-version":[{"id":26132,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/15388\/revisions\/26132"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=15388"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=15388"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=15388"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=15388"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}