Unable to extend sys_user table

Arunkumar4
Tera Contributor

In my Orlando instance, I am unable to extend the sys_user table. When I check the sys_user table, the extensible checkbox is false... Is this default feature in Orlando or issue in my instance?

10 REPLIES 10

Mwatkins
ServiceNow Employee
ServiceNow Employee

FYI - Over the last year it has become apparent that extending from sys_user can lead to undesirable results.

See Nia Cash and Jace Benson's blog posts that explain how this could force a user to have two accounts - as was explained in the SNDevs slack community:

https://jace.pro/post/2021-08-12-extending-user-is-bad/

https://community.servicenow.com/community?id=community_article&sys_id=d8e645a2dbadf810da1999ead3961...

There is also a performance concern as reference auto-complete and lookup on the sys_user table are very frequent and resource intensive operations. It has been found that in some cases these operations do not perform well when the table size of sys_user reaches around 1 million. The exact size of the table necessary to cause performance issues will be influenced by many factors including the complexity of reference qualifiers or auto-complete settings and, thus, performance issues might be observed at smaller sizes. Conversely if auto-complete and reference qualifiers are highly optimized and efficient, then performance might be maintained even at larger sizes.

Please Correct if this solves your issue and/or 👍 if Helpful

"Simplicity does not precede complexity, but follows it"