Author Topic: Increase login/username length to 64 characters  (Read 4853 times)

Jacek Pliszka

  • EA Novice
  • *
  • Posts: 4
  • Karma: +0/-0
    • View Profile
Increase login/username length to 64 characters
« on: October 07, 2013, 09:37:05 pm »
Could you increase login/username length from 32  to 64 characters?

We would like to have e-mail as logins and several of our users have 40+ characters e-mails


skiwi

  • EA Expert
  • ****
  • Posts: 2081
  • Karma: +46/-82
    • View Profile
Re: Increase login/username length to 64 character
« Reply #1 on: October 11, 2013, 12:35:35 pm »
and this is related to the forum, EA's website, Sparx EA, or ...
Orthogonality rules
Using EA16.1 (1627) on Windows 11 Enterprise/64 bit. Repositories in SQLServer2019 DB Schema 1558.
WebEA on Pro Cloud Server 4.2.64

Jacek Pliszka

  • EA Novice
  • *
  • Posts: 4
  • Karma: +0/-0
    • View Profile
Re: Increase login/username length to 64 character
« Reply #2 on: October 11, 2013, 07:52:01 pm »
Sorry, I meant Sparx EA - currently the logins are 32 characters.


qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +396/-301
  • I'm no guru at all
    • View Profile
Re: Increase login/username length to 64 character
« Reply #3 on: October 14, 2013, 07:56:13 am »
I guessed that ::)

Sparx is quite reluctant with such changes. So chances are low.... Anyway, if I were a user that had to log on with a 40+ mail address I'd start cursing each time I had to use the system. Why don't you use the integrated Windoze authorization?

q.

Jacek Pliszka

  • EA Novice
  • *
  • Posts: 4
  • Karma: +0/-0
    • View Profile
Re: Increase login/username length to 64 character
« Reply #4 on: October 14, 2013, 07:39:42 pm »
> Anyway, if I were a user that had to log on with a 40+ mail address I'd start cursing each
> time I had to use the system.

Why ?

EA remembers user login - you just click OK - no need to enter it every time.

> Why don't you use the integrated Windoze authorization?

Users are from 3 different companies - all they got in common is PostgreSQL EA database.

We do have shared Linux OpenLDAP (used for sftp, svn, web etc.) - login is by e-mail
and the easiest for us would be just connect EA to it.
 

« Last Edit: October 14, 2013, 07:40:16 pm by jacek.pliszka »

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +396/-301
  • I'm no guru at all
    • View Profile
Re: Increase login/username length to 64 character
« Reply #5 on: October 14, 2013, 09:36:53 pm »
You might try the following: change the t_secuser.userlogin to take 64 chars. I have no idea if EA will do any internal truncation. But it's worth a try. Just create a user with more than 32 chars and see whether you can log on and whether you can modify that user.

Don't try that with your production server. Use a test schema!

q.

Jacek Pliszka

  • EA Novice
  • *
  • Posts: 4
  • Karma: +0/-0
    • View Profile
Re: Increase login/username length to 64 character
« Reply #6 on: October 14, 2013, 10:03:39 pm »
We've already done it some time ago - the change is now on our production server.

But it would be much safer for us if it were officially 64.

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +396/-301
  • I'm no guru at all
    • View Profile
Re: Increase login/username length to 64 character
« Reply #7 on: October 14, 2013, 10:27:14 pm »
You should send the request officially to Sparx (use the link bottom right of this page). Probably if it more or less works without much effort they might consider to make it an official change. Cross fingers...

q.