"sp_displaylogin" equivalent in IQ?

[Former Member]

Hi, there doesn't seem to be a system stored procedure in IQ which does the equivalent of sp_displaylogin in ASE. Does anyone have a custom one? Or is there an IQ one which I have just not seen?

Thanks!

[tayeb_hadjou]

Hi David,

I'm not aware of such procedure, but queries below may help to write your own proc.

1-

select U.user_id, U.user_name, U.expire_password_on_login, U.password_creation_time, U.failed_login_attempts, U.last_login_time, U.user_type, U.user_dn,U.user_dn_cached_at, A.resourceauth, A.dbaauth, A.scheduleauth, A.user_group, P.login_policy_id, P.login_policy_name

from SYSUSER U, SYSLOGINPOLICY P, SYSUSERAUTH A

where

U.login_policy_id=P.login_policy_id and

U.user_name=A.name and

U.user_name='tayeb' ;

2-

select role_name, grant_type, grantor from  SYSROLEGRANTS

where

grantee_name='tayeb';

Regards,

Tayeb.