0 votes

Hello,

Might be a simple question, but where is the sso information stored in the database (see printscreen)?

enter image description here

In versions prior to 11 this was stored in ACC_ACCOUNTS (SSOID) but this isn't the case as of version 11.

Thank you for the clarification.

Regards,
Ken

asked in Database by (197 points)

1 Answer

+1 vote
Best answer

Hi Ken

This is stored in ACC_AUTH. If you want to see the data of Adminstrator (K_USER=2), filter with these conditions:

select USERNAME, KIND from ACC_AUTH where K_TABLE=1000 and K_1=2
  1. KIND=1002 is SSO
  2. KIND=1003 is BEID
  3. KIND=1004 is LDAP
  4. KIND=2001 is Qlik
answered by (7.4k points)
selected by
Thank you very much for the info!
1,249 questions
1,518 answers
1,858 comments
328 users