SQL Update sys_logins table
Posted on 2013-11-21
Is there a way for me to update the sys.sql_logins table? I would like to turn on password policy and expiration. However, I do not want to do it one by one. I would like to be able to do a mass update with user that does not have this on. Any ideas?
set is_policy_checked = 1,
is_expiration_checked = 1
where is_policy_Checked = 1 or is_expiration_checked = 1
Getting the following error.
Ad hoc updates to system catalogs are not allowed.