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_iqcopyloginpolicy ‘existing-policy-name’, ‘new-policy-name’

Syntax3

sp_iqcopyloginpolicy existing-policy-name, new-policy-name 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)).

Permissions

Requires DBA authority.

Examples

The following stored procedure 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')