Creates a new login policy by copying an existing one.
call sp_iqcopyloginpolicy (‘existing-policy-name’, ‘new-policy-name’ )
sp_iqcopyloginpolicy ‘existing-policy-name’, ‘new-policy-name’
sp_iqcopyloginpolicy existing-policy-name, new-policy-name policy_name ]
existing policy name The login policy to copy.
new policy name Name of the new login policy to create (CHAR(128)).
Requires DBA authority.
CREATE USER Statement in Chapter 1, “SQL Statements,” in Reference: Statements and Options
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')
