What is relationship between authentication profile and user record in user table.

[niveditakumari]

Hi, 

What is relationship between authentication profile and user record in user table. 

We are having rest message and in authentication profile we are using one record 'abc' and that record was available in user table but it was inactive because of that our integration was not working. I have corrected that and made that user record 'abc' active in user table and now integration is working. 

Record in 'sys_auth_profile_basic' table : 

Name : IBS USer 

Username : abc1 

Password : ****** 

Record in 'sys_user' table 

User ID : abc1 

First Name : abc 

Last Name : 1

Does it necessary to create record in both places. 

Can anyone please confirm relationship between record in 'sys_auth_profile_basic' and 'sys_user' table. 

Regards, 

Nivedita

[Anand Kumar P · Accepted solution]

Hi @niveditakumari ,

The sys_auth_profile_basic table is used for storing credentials (username and password) for REST integrations, while the sys_user table contains user records. There is no direct relationship between the two, but if the integration or custom logic validates the username against the sys_user table, the user must exist and be active in sys_user.

For example, if the REST message uses an authentication profile with username abc1 and ServiceNow checks this against sys_user for roles or permissions, the user abc1 must be active in sys_user. Without an active user, the integration may fail due to permission or authentication issues.

Mark it as helpful and solution proposed if it serves your purpose.
Thanks,
Anand

[Runjay Patel]

Hi @niveditakumari ,

ServiceNow maintain user integrity using userid which present in user table. To authenticate any user in ServiceNow we need to create an user in sys_user table.

Once you create oauth profile system by default create an user record in user table.

Accept the solution if it helped.

[Community Alums]

Hi @niveditakumari ,

Basic Authentication Configurations are stored in Table(sys_auth_profile_basic). This is primary used for integrations.

sys_auth_profile_basic table is part of something called Authentication Profiles, which is like a toolkit for managing login details across multiple places. Instead of setting up your username and password every single time for each connection, you can create a profile in this table and reuse it wherever you need it. This is more organized and makes things easier to manage if you have a bunch of different connections to handle.

For REST messages specifically you must use thesys_auth_profile_basic table because that's what ServiceNow is looking for as far as credential records.

'sys_user' table is not part of the above table and it is not necessary to create record in both places.

[niveditakumari]

Hi @Community Alums, 

Got it. Integration was not working today when we made that user record active in user table then only integration worked. 

Can you please make me understand for that. 

Regards, 

Nivedita