Book a Demo

Author Topic: AD authentication and password column on t_secuser  (Read 3447 times)

Modesto Vega

  • EA Practitioner
  • ***
  • Posts: 1183
  • Karma: +30/-8
    • View Profile
AD authentication and password column on t_secuser
« on: February 10, 2022, 01:51:20 am »
The t_secuser table contains a password column which is populated for all our Active Directory users. I have 3 questions:
  • Does it play a role when using AD authentication?
  • What is it used for?
  • How does it get populated?

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +397/-301
  • I'm no guru at all
    • View Profile
Re: AD authentication and password column on t_secuser
« Reply #1 on: February 10, 2022, 04:33:24 am »
For AD it's not used, only when working offline (and if you haven't told to use AD).

q.

Modesto Vega

  • EA Practitioner
  • ***
  • Posts: 1183
  • Karma: +30/-8
    • View Profile
Re: AD authentication and password column on t_secuser
« Reply #2 on: February 10, 2022, 07:59:43 pm »
Thank you Thomas. All our AD user records have the password populated and I would really like to know where are those passwords coming from. I am also assuming that PCS is not using them.

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +397/-301
  • I'm no guru at all
    • View Profile
Re: AD authentication and password column on t_secuser
« Reply #3 on: February 10, 2022, 09:26:08 pm »
Well, EA does not look into them when using AD. You can probably regard them as garbage then? Or are you afraid of hacking? In that case sit back. The hacker door is open as wide as could be since any EA user has full access to the whole database with no restrictions.

q.

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13523
  • Karma: +574/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: AD authentication and password column on t_secuser
« Reply #4 on: February 10, 2022, 09:46:23 pm »
Well, EA does not look into them when using AD. You can probably regard them as garbage then? Or are you afraid of hacking? In that case sit back. The hacker door is open as wide as could be since any EA user has full access to the whole database with no restrictions.

q.
The concern is legitimate. If EA would store the password (like it did in the past with an unsalted hash) you could have a security issue on your hand.
A lot of users re-use password.

If I were to get my hand on a list of users and their passwords, I could try those passwords on their gmail, facebook, etc... accounts.

The fact that the model can be accessed fairly easily is not really my concern. The model doesn't contain any secrets anyway.

But anyway, since a user that is imported from AD never enters his password in EA, there is no way EA can register the actual password (in a hashed form or otherwise)
I'm not sure what is actually stored in that field.
For AD users it might be the password hash from AD (although I doubt that, I don't think that is actually possible), but more likely it's another kind of hash, or just rubbish.

For regular, non AD users, it's definitely a hashed password, but I believe in recent versions it's at least salted (users with the same password have a different hash)
No idea about the actual hashing algorithm used and whether or not that is a secure algorithm fro hashing passwords.

The main security risk here is not allowing access to EA's model (that can be controlled on the database level), but exposing users passwords.
By using AD users you don't have that risk anymore.

Geert