What is the user and Table name for user table?

[ShivaR437725225]

A user is a record that corresponds to aset of permissions (roles) and groups, and of course, to a real person.

  Table name of Users "SYS_USER"

[Nayan ArchX]

Also,

Each user has a unique sys_id.

The group table name: sys_user_group

The Role table name: sys_user_role

If my response has resolved your query, please consider giving it a thumbs up ‌‌ and marking it as the correct answer‌‌!

Thanks

Nayan Patel

IT ServiceNow Consult, ServiceNow ArchX

If my response has resolved your query, please mark it Helpful by giving it a thumbs up and Accept the Solution

👉https://www.scirp.org/journal/paperinformation?paperid=149299

👉 https://scholar.google.com/ 

[Aditya_hublikar]

Hello @ShivaR437725225 ,

A user in ServiceNow is an individual record, stored in the sys_user table, representing anyone authorized to log into and access the platform. These records, which include details like Name, Email, Roles, Department, and Manager, are essential for identifying users, managing security access, and facilitating tasks. 

Every user has some roles (which stored in sys_user_role table ) through which they can access corresponding tables,modules . In servicenow its good practice to assign roles through groups.

Groups are stored in (sys_user_group table).A group in ServiceNow is a collection of users who share a common purpose, such as answering tickets, approving requests, or managing configuration items    

If this helps you then mark it as helpful and accept as solution.

Regards,

Aditya

[Aditya_hublikar]

Hello @ShivaR437725225 ,

 you can refer this thread : https://www.servicenow.com/community/community-resources/understanding-user-and-group-administration...

[Nayan ArchX]

Yes, the article only mentions users and groups, but roles.