sp_iqcopyloginpolicy Procedure

Creates a new login policy by copying an existing one.

Syntax1

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

Syntax2

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

Usage

Parameters

Parameter

Description

existing policy name

The login policy to copy.

new policy name

Name of the new login policy to create (CHAR(128)).

Privileges

Requires the MANAGE ANY LOGIN POLICY system privilege.

Examples

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')