Note: This will only work with SQL logins.
The following query will generate the results below.
SELECT SP.name
,LOGINPROPERTY(SP.name,N'PasswordLastSetTime') 'LastPWReset'
FROM sys.server_principals SP
WHERE SP.[type] = 'S'
Tuesday, February 23, 2016
List of Users Who Recently Changed Their Password
There may come a time when you need to generate a list of SQL logins and the last time their password was changed. By using the LOGINPROPERTY of the name in sys.server_principals we can generate such a list.
Note: This will only work with SQL logins.
The following query will generate the results below.
SELECT SP.name
,LOGINPROPERTY(SP.name,N'PasswordLastSetTime') 'LastPWReset'
FROM sys.server_principals SP
WHERE SP.[type] = 'S'
Note: This will only work with SQL logins.
The following query will generate the results below.
SELECT SP.name
,LOGINPROPERTY(SP.name,N'PasswordLastSetTime') 'LastPWReset'
FROM sys.server_principals SP
WHERE SP.[type] = 'S'
Subscribe to:
Post Comments (Atom)
ARINET DBA Services is a Chicago, IL based organization established in 2013. Uniting more than 100+ years of combined involvement in giving quality Oracle database Support administrations to American organizations, we've given the diverse options about remote dba masters, remote dba services, remote dba reinforce, remote database, oracle remote, dba remote, database association, prophet dba reinforce, Oracle sponsorship and Oracle Consultants.
ReplyDelete