Displaying a List of Users Assigned a Login Policy

Before you can drop a login policy, ensure that it is not currently assigned to any users.

To display the users assigned to a login policy, select from the SYSUSER system view based on the login policy identifier.

Example:

This statement lists users assigned to the lp1 login policy:

SELECT user_name FROM sysuser WHERE login_policy_id = ( SELECT login_policy_id FROM
    sysloginpolicy WHERE login_policy_name='lp1' )