# Is it safe to expand LOGIN\_ACCOUNT.CREATED\_BY column?

**URL:** <https://discourse.project-emerse.org/t/is-it-safe-to-expand-login-account-created-by-column/27>\
**Category:** Uncategorized\
**Created:** [August 27, 2019, 9:48pm UTC](https://discourse.project-emerse.org/t/is-it-safe-to-expand-login-account-created-by-column/27 "2019-08-27T21:48:45Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![EricMeeks](https://avatars.discourse-cdn.com/v4/letter/e/5f8ce5/32.png) [@EricMeeks](https://discourse.project-emerse.org/u/EricMeeks)\
**Post date:** [August 27, 2019, 9:48pm UTC](https://discourse.project-emerse.org/t/is-it-safe-to-expand-login-account-created-by-column/27/1 "2019-08-27T21:48:45Z")

</div>

We’ve added Shibboleth login to Emerse, using our EPPN for the Login ID within Emerse. However, our EPPN’s are 15 characters long, and while that works for standard login, it creates this issue when we try and add new users from an EPPN based administrator:

Caused by: oracle.jdbc.OracleDatabaseException: ORA-12899: value too large for column “EMERSE”.“LOGIN\_ACCOUNT”.“CREATED\_BY” (actual: 15, maximum: 12)

A few ways we could solve this, but I’d prefer to just expand the CREATED\_BY column in that table. It actually seems like a bug that this column doesn’t match the size of the USER\_ID column as they both reference the same data.

So this in the create/update SQL:  
ALTER TABLE EMERSE.login\_account ADD created\_by VARCHAR2(12);  
should instead be:  
ALTER TABLE EMERSE.login\_account ADD created\_by VARCHAR2(50 BYTE);

---

<div class="post-metadata">

**Author:** ![jlaw](https://avatars.discourse-cdn.com/v4/letter/j/d07c76/32.png) [@jlaw](https://discourse.project-emerse.org/u/jlaw)\
**Post date:** [August 29, 2019, 12:34am UTC](https://discourse.project-emerse.org/t/is-it-safe-to-expand-login-account-created-by-column/27/2 "2019-08-29T00:34:57Z")

</div>

Eric, I think this should be fine. I checked the admin app- which allows 32 chars and the database mapping allows for 50 and I can’t think of any validation or manipulation that the code does with ID.

–james

---

<div class="post-metadata">

**Author:** ![EricMeeks](https://avatars.discourse-cdn.com/v4/letter/e/5f8ce5/32.png) [@EricMeeks](https://discourse.project-emerse.org/u/EricMeeks)\
**Post date:** [August 30, 2019, 8:06pm UTC](https://discourse.project-emerse.org/t/is-it-safe-to-expand-login-account-created-by-column/27/3 "2019-08-30T20:06:02Z")

</div>

Yep. We went ahead and made the change and everything is fine. Thanks!