login policy

[Former Member]

Hi Guys,

I assigned a login policy to a user.

But how to check which user is having which login policy in SAP IQ 16 SP04 using procedure or query.

Thanks in Advance,

Santosh

[tayeb_hadjou · Accepted solution]

Hi Santosh,

You can use this query :

select U.user_id, U.user_name, P.login_policy_id, P.login_policy_name

from sysuser U, sysloginpolicy P

where U.login_policy_id=P.login_policy_id

and U.user_name=<user_name_in_question>

Regards,

Tayeb.

[Former Member · Accepted solution]

Thanks Tayeb,

It's working.

[Former Member · Accepted solution]

Hi Santosh,

Please mark the question as being answered by Tayeb.

thanks!

jason