sp_iqcopyloginpolicy Procedure

Creates a new login policy by copying an existing one.

Syntax 1

call sp_iqcopyloginpolicy (‘existing-policy-name’, ‘new-policy-name’ )

Syntax 2

sp_iqcopyloginpolicyexisting-policy-name’, ‘new-policy-name

Parameters

Privileges

You must have EXECUTE privilege on the system procedure, as well as the MANAGE ANY LOGIN POLICY system privilege.

Example

Creates a new login policy named lockeduser by copying the login policy option values from the existing login policy named root:

call sp_iqcopyloginpolicy ('root','lockeduser')
Related reference
sp_expireallpasswords System Procedure
sp_iqaddlogin Procedure
sp_iqmodifylogin Procedure
sp_iqpassword Procedure
Determining the Security Model Used by a Database