Set password expiry for external SharePoint website

Question

I have an external SharePoint website where I need to set the password expiry policy.

After a certain period of time, e.g. 30 days, the user passwords expire and they are required to change it.

So in which way should I proceed?

Answer 1

MySQL is used in the backend. However I achieved this using this Stored Procedure in MySQL .

CREATE PROCEDURE [dbo].[SP_Validate]
@Username nvarchar(50)
AS
BEGIN
declare @CreatedDate datetime
declare @DiffDate int
if exists( select top 1 * from Test_Users where UserName = @username)
begin 
select @CreatedDate = UpdateTime from Test_Users where UserName = @username;
SELECT @DiffDate = DATEDIFF(day,@CreatedDate,GETDATE()) ;
if(@DiffDate < 60)
select 1
else 
select 0
end
else 
begin 
select 0
end
END