An Oracle Spin by Alex Lima

Sharing Tips & Tricks from my Database Experience

Menu Skip to content
  • Home
  • GoldenGate
  • General DBA
  • Oracle White Papers
  • Disclosure
  • About
June 12, 2011February 9, 2016 Alex Lima

The CHECK_POLICY and CHECK_EXPIRATION options cannot be turned OFF when MUST_CHANGE is ON

When a user account is created on SQLServer on 2005 with user account set to “Enforce password policy” and “Enforce password expiration”, once set this policy and expiration can’t be changed using.

ALTER LOGIN test WITH CHECK_EXPIRATION = OFF;
Or
ALTER LOGIN test WITH CHECK_POLICY = OFF;

SQLserver will return the following message
Msg 15128, Level 16, State 1, Line 1
The CHECK_POLICY and CHECK_EXPIRATION options cannot be turned OFF when MUST_CHANGE is ON.

To fix this issue which will keep the password the same and it will turn off check policy and expiration.
ALTER LOGIN test WITH PASSWORD = ”
GO
ALTER LOGIN test WITH
CHECK_POLICY = OFF,
CHECK_EXPIRATION = OFF;

Share this:

  • Email
  • Tweet
  • Share on Tumblr
  • Telegram
  • WhatsApp

Like this:

Like Loading...
  • SQL Server
  • ALTER LOGIN
  • CHECK_EXPIRATION
  • CHECK_POLICY
  • Msg 15128
  • off
  • turned

Published by Alex Lima

View all posts by Alex Lima

Post navigation

Previous How to get current session id, process id, client process id?
Next How to list indexes and the column names?

You must log in to post a comment.

Follow Me

  • Twitter
  • LinkedIn
  • YouTube

Categories

  • 18c (2)
  • 19c (4)
  • AIX (1)
  • Archivelog (3)
  • Auditing (2)
  • AWR (10)
  • Backup (4)
  • Backup & Recovery (35)
  • Batch (1)
  • Big Data (1)
  • Built-in stored procedures (1)
  • Connections (1)
  • Control file (3)
  • Cursor (3)
  • Database (12)
  • Dataguard (4)
  • Dataguard (3)
  • Datatypes (6)
  • Date (2)
  • Docker (1)
  • exp (2)
  • Export (6)
  • Flashback (5)
  • General DBA (274)
  • Globalization (6)
  • GoldenGate (30)
  • Grant (5)
  • Initialization (4)
  • install (2)
  • Internal (4)
  • JDBC (5)
  • Jobs (4)
  • Linux (1)
  • Listener (4)
  • LOB (2)
  • Lock (3)
  • Log Miner (1)
  • mac (2)
  • Microservices (15)
  • Monitor (1)
  • MySQL (2)
  • NetApp for Oracle (2)
  • OCI (2)
  • OEM – Grid Control (5)
  • OpenWorld 2010 (3)
  • ORA Errors (3)
  • Oracle RAC (4)
  • oradebug (9)
  • OS (2)
  • osql (1)
  • Parameters (8)
  • partition (1)
  • Password (3)
  • performance (1)
  • PL/SQL (5)
  • postgres (1)
  • Power Shell (2)
  • Primavera (3)
  • Profiler (1)
  • Project Management (3)
  • REST API (3)
  • RMAN (36)
  • role (3)
  • Scheduler (9)
  • Scripts (26)
  • Security (7)
  • sga (4)
  • Shared Pool (3)
  • Shell (15)
  • snapshot (1)
  • SQL – DDL (5)
  • SQL Developer (3)
  • SQL Server (69)
  • SQL*Plus (18)
  • SQLcl (2)
  • startup (4)
  • Statistics (14)
  • Statspack (3)
  • Table (3)
  • tablespace (2)
  • trace (32)
  • Transaction (5)
  • Tuning (35)
  • Tuning (6)
  • Undo (1)
  • Unix (33)
  • Upgrade (1)
  • vi (5)
  • windows (9)

Follow Alex's Blog

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 103 other subscribers

Twitter Updates

  • Now, that's something i can get fully behind it. Technology and innovation without necessary fully disrupt our way… twitter.com/i/web/status/1… 7 hours ago
  • Getting my #Finance on with @QuanticSchool course Finance: The Time Value of Money #GetMoney #ModernMBA app.quantic.edu/course/learn-f… 8 hours ago
  • #SundayFunday https://t.co/WiyOsxtDas 8 hours ago
  • #DateNight with soulmate. https://t.co/XCN2utWsbh 1 day ago
  • Friday....... #FridayFeeling #FridayFunday https://t.co/Yv2arXLoI5 2 days ago
Follow @aoflima

Recent Posts

  • Oracle GoldenGate Advantages
  • GoldenGate Automation with REST API and Python
  • Where is the TNS_ADMIN in GoldenGate Microservices 21c?
  • GoldenGate Lifetime Support Schedule
  • Oracle MAA Never Down Series

Top Posts

  • How to delete archive logs already archived to backup device?
  • ALTER DATABASE BEGIN/END BACKUP
  • How to find jobs currently running or history about the jobs?
  • How to stop a job scheduled in DBMS_SCHEDULER?
  • How to see current utilization of processes/sessions and max utilization?
  • How to lock/unlock statistics on a table?
  • How to find the NLS_LANG to set for a database?
  • Install Chrome on Oracle Linux 7 (REHL7)
  • ORA-28221: REPLACE not specified
  • How to delete/reset a parameter in spfile using ALTER SYSTEM?
Powered by WordPress.com.
Go to mobile version
%d bloggers like this: